Choose number of samples for Random % Sample

[MiroPwC]

Hey guys,

I would like to ask you for a little help with my code. I  MUST use random % sample to select samples from the defined data set (around 50 000 rows). However, this function only allows me to manually input the number of samples. But the number of samples is always different and is calculated within my workflow (column 1 / column 2 * column 3 = Column "Number of samples" and numbers in columns change based on user input).

My question is, how can I "tell" to the random % sample function to select the number of samples based on mine calculation without manually inputting the number to the function ? The number should be taken from column "Number of samples"(for instance 11 samples).

Thanks in advance for your advices 🙂

[afv2688 · Accepted solution]

Hello @MiroPwC,

Try using this

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[MiroPwC]

Thanks a lot. Works like magic.