Selecting a sample of n random records from a table based on data

Adriankp

Hello,

I'm currently in a position where I have to select records from a table randomly, but how many records are to be selected is going to change from run to run, and is based on the result of an API call in the same workflow. So using the Random % Sample tool is unfortunately not a possibility.

To break it down, I have one data stream containing a table of records where a random sample has to be made, and one data stream containing information about how many records are to be selected at random from the table (just the number of records in int format). I'm thinking there should be some kind of workaround solution to achieve this, but am currently drawing blanks.

Any input is highly appreciated!

Thanks!

gautiergodard

Hello @Adriankp,

I would try a batch macro for this use case.

See below for how i would recommend building.

Hope this helps!