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.

sample.yxmd