community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Random Sampling by group

Atom

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.

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

 

Capture.PNG

 

See the attached v11.0 workflow

Highlighted
Atom

Thanks!

Labels