Selecting 100 rows from a sheet

Follow

Ganesh Saptharishi

• May 03, 2021 05:47

Hi All,

I need to extract a sample of 100 records from a big volume of 30 million records for a reconciliation purpose. please suggest how to go about the same.

 

Thanks in advance

 

0

• 

  Konsta Danyliuk

  • May 03, 2021 06:02

  Hello Ganesh.

  • If you just need 100 random records from the dataset, you could sort by any column and then use the Top N property to display the first N records.
  • In case you would like to really randomize the selection, you could add a new column with the RAND() function in it and then sort by this column.

  I hope this helps.

  0

  Comment actions Permalink

Please sign in to leave a comment.