Select Random records

#1

I have built a dataset that has multiple rows for a given column "ID". How can I select a random 5 rows from each unique "ID"?

Basically I'm trying to get just a small sample set of data from each "ID"

#2

Calculate a random column using the random() function. Then use the "Keep min/max" action to keep only the 5 max random numbers for each ID.

See the example below:
random-in-group.morph (3.1 KB)

#3

Of course - thank you. I was way overthinking this.