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.
User | Count |
---|---|
109 | |
89 | |
77 | |
54 | |
40 |