Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Selecting samples based on selected fields from population data

DeorajK
7 - Meteor

I'm designing an alteryx app to select dynamic sampling data from the population data.

The attached workflow would produce the below results. From these results, I would like to select the number of records from field "# to select in sample (equal)" with the respective category in field "n_Test_Name" from the population data randomly.  Population data at the sort tool highlighted below in the workflow.

e.g., 

Seven records would be selected from the population randomly with category "FULL NAME"

Seven records would be selected from the population randomly with category "LASTDATE"  etc. 

All records selected must be union together into a final dataset.

 

Sample tool data.png

 

Sample tool WF.png

 

 

0 REPLIES 0
Labels
Top Solution Authors