GROUPED RANDOM SAMPLING

[Gratus_tz]

Hi Everyone,

I have an Inquiry Regarding the Samples where I want to be able to pick Samples lets say in a GL which has a column of Accounting Codes but I want to pick my samples Randomly from each Account Code because if I set a normal Random Sample Function there some Accounts code are not Picked so what can I do.

Please Help! Thank you

[Mathias_Nielsen]

Hi,

IDK if there is a simpler way, but you could make a batch macro choose the account code as the group by and control parameter field. Put your sample tool inside the macro and then the macro will do a sample for each of your account codes :)

[ntakeda]

Hi @Gratus_tz 

You can implement this by doing the following:

1. Use the random function in the Formula tool.
2. Sample using the Sampling tool.

Each account code output 2records (or 1record if there is only 1 record).

I have attached the workflow. Please check it.