We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Select at least one sample from each group

tww
8 - Asteroid

Hi all,

 

Refer to the input table below. Could someone show me how to build a workflow that would select at least one sample from each group (in this case 4 samples). And if let's say the sample size is 5. It would pick one from each group and then select the extra one from the group with highest frequency, in this case, from Group C.

 

GroupCode
A24
A73
C220
B661
C1984
C5953
C17860
C53581
B160744
B482233

 

Thank you in advance for your help

 

TWW

2 REPLIES 2
geraldo
13 - Pulsar

@tww 

 

AN WORKFLOW EXAMPLE

tww
8 - Asteroid

Thank you, @geraldo 

Labels
Top Solution Authors