Sort Data Table randomly

[jose_rlc1 (Jose)]

Hi community!
I want to sort a Data Table randomly, I mean, I want my DT in different order every time I run the process.
Is there any activity or property to sort randomly?
Thanks!

[Vaibhav_Rajpoot_17 (Vaibhav Rajpoot)]

@jose_rlc1

You can use the sort datatable activity .
have a look on this thread->

Sort Data Table

[Yoichi]

Hi,

How about the following?

rnd = new Random()

dt = dt.AsEnumerable.OrderBy(Function(r) rnd.NextDouble).CopyToDataTable

Note: it mgiht be needed to input proper random seed to random instance.

Regards,

[Veera_Raj (Veeraraj Sethuraman)]

you can use sort table activity and there are two options are there you can sort by ascending or descending

[jose_rlc1 (Jose)]

Perfect! Thanks a lot!