How to select a conditional sample?

[johnnyacm]

Hello community

I have the following question, I must select a sample from my database (input) with a quantity according to the condition of lines that the data contains (see image), I would like to know how to do it since with the sampling tools I have not seen solution

TKS 

[SPetrie]

There may be a macro or better solution, but a quick way is to use random numbers to create your own sampler.

I used the record count to get the total number of lines. I created a random number for each line and used a formula to assign the size of the sample I want based on the record count. Then I sorted by the random number and assigned a new record id after the sort. A filter tool removes any id that is greater than the number of records I want.

I used the alphabet as the example input in the workflow.

[Qiu]

@johnnyacm 
Agree with the Batch Macro.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Sample-Tool/td-p/17516

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/dynamic-change-of-sample-size-...