I’m not really sure how you would do this or what youre exactly asking for ?
Do you want to just “shuffle” the current datasheet ? if thats the case i wouldnt know really…
If you want to pick random rows, then you could assign a random number to a variable :
Assign : [randomNumber] = [new Random().Next(1,10) ] ( if there are 10 rows)
Then you can use the “for each row”
and if row index = random number > Then
See attached robot.
RandomRowSelector.xaml (13.0 KB)
Edit : Thinking on this more, if you did want to make it a “shuffle”, you could store each random number in a list then filter that out. That way you would never get the same row twice. Im not sure how you would tell the bot when its “done” tho, as it would still select the random numbers, but it would just not do anything with them…
So when a number is selected = add that number to list
then do a for each item in list = if list = random number = do nothing.
so only new numbers will be selected as the row indexes.
There is probably a simpler way to all of this, Im still very new to coding / uipath.