Random Sampling by group

[mapp2]

Hi all,

I have a large data file that I have read in which contains over 50 periods. I would like to randomly select 10 records from each period. How is this possible?

Thanks in advance.

[patrick_digan · Accepted solution]

@mapp2 I would use the Rand function, sort on your period and rand, and then sample the 10 records:

See the attached v11.0 workflow

[mapp2]

Thanks!