Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Random Selection by Group Not Working

Drakitha
5 - Atom

Hello,

 

I have a file that comes in every day with random accounts. I need to sample some from each Taxing authority, so I used the sort and group by function. However nothing is pulling to my sample from the workflow, it is just coming up blank.

 

Am I doing something wrong?

 

Drakitha_0-1686838283869.png

 

1 REPLY 1
alexnajm
17 - Castor
17 - Castor

What's the configuration of your Sample tool? I would likely select "1 in N chance to include each row" if you want it to take a random amount each time.

 

Otherwise you could look at the Random % Sample tool if you don't need to group by anything / use it to create a batch macro to do it for each group of data.

Labels