How pick randomly 1000 rows from datatable where datatable contains 10k

Help
, , ,
1

Hi Team,

I have an excel with 10000 records and i want to form a other datatable with only 1000 records where 1000 picked randomly from whole datatable. Bot should not pick top 1000 or last 1000. Please help me on this.

Thanks in advance…!!

2

Try this;

  1. Order the rows in a data table randomly.

  2. Take the 1000 rows from the randomly ordered data table.

    Dim rand = New Random()
    Dim employees = employee.AsEnumerable().OrderBy(Function(rn) rand.Next).Take(10)

Regards,
Karthik Byggari

2 Likes
3

Hi Kathik,

Using above syntax i’m getting top rows only it is not picking randomly.
Please see the image.

image
image932×242 12.2 KB

4

How many rows are in dt1?

5

total 5 rows

image

6

when printing using for each row always first 3 rows only printing.

image

7

Can you please try with more than 10 rows and let me know if the result is same.

8

Yes results are same.

9

@nagarameshkola

Welcome to the uipath community.

Please check below thread and give it a try once.

How to get the unique records randomly from Data Table???

10

Okay. Let me check from my side and let you know the output.

Regards,
Karthik Byggari

11

Hi,
I am also getting only the top rows

Error
Error752×221 6.46 KB

Is there any solution to this?

12

Hi @Needhelp

Wait I will check and let you know the findings.

13
14

Hi @Needhelp

I posted a custom activity in the UiPath Connect.

Please download the package from here -

It will be soon available in the Manage Packages.

Regards,
Karthik Byggari

15

Hi,

It says that the resource does not exist

16

Oops. Can you send me the error screenshot to analyse.

18

I guess the component is in review. I will let you know once it is available in connect.
Sorry for delay.

19

Can any one please provide the solution for this

Thanks
T.Somswaran

20

This worked for me in uipath. Just kept “Rand” s type as random.