Selecting 100 rows from a sheet


1 comment

  • Konsta Danyliuk

    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.

    Comment actions Permalink

Please sign in to leave a comment.