Copy 25 random rows from Data table

Help Studio
1

Hey guys, maybe this is super easy but cant figure it out right now.

I have a excel with 261 rows read into a datatable. I need to randomly choose 25 of those rows and copy to a new Datatable.

  • Right now i have used new.random().next to create a datatable with 25 rows of random numbers. the idea was to use those numbers to define what rows to copy, but i am stuck. Maybe there is an eaiser way?

Any ideas?

2

@thomasb82
maybe similar to your approach, feel free to have a look on it:
RandomRowsRetrieval.xaml (8.7 KB)

3

Thanks for that!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.