GROUPED RANDOM SAMPLING

Question

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

ntakeda · Answer

Hi @Gratus_tz

You can implement this by doing the following:

* Use the random function in the Formula tool.
* 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.

Group Random.yxmd

Mathias_Nielsen · Answer

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 :)