How to sort rows into a random order?

Question
1

If I have a table like this:

ID Value
00001 77.8631020231
00002 61.2627402421
00003 61.4798339552
00004 78.7758658285
00005 27.5233861997
00006 82.3734202054
00007 36.2520038753
00008 15.3953478626
00009 35.2214229925
00010 33.2337423955

How do a sort the rows into a random ordering?

2

You need to:

  • Use the Random transform to add a column of random values.
  • Use the Sort transform to sort by the random value column.
  • Use the Remove Cols transform to remove the column of random values.

image
image693×120 28.9 KB

image

sort-random-row-order.transform (3.0 KB)