Sample data based on frequency distribution

Question

Dear fellow Alteryx fans,

I'm currently struggling to create sample data based on a distribution.

The input data looks like this: for each time interval (Name) the frequency is given (Bin) (please ignore column Total).

My goal is to generate a 10k random value bassed on this sample distribution. In total, there are around 30 different sample distributions.

I looked into using the Data Sampling Tool, however could not generate the desired output and had the feeling that the performance is not the best.

Does anyone has an idea how to approach this differently?

Thank you in advance for your help!

Michael

sample.xlsx

mi_schmidt · Answer

Hi @Raj_Singh1 ,

Thanks for providing your solution.

I had checked and it runs smoothly, however I'm actually looking for a reversed version of your workflow: my desired output is your input 🙂

Best

Michael

Raj_Singh1 · Answer

Hi @mi_schmidt

Please see excel file to go as input(select tabella2 sheet) from the one i am attaching.

and aslo the workflow. it should work for 10k values if i got it right. maybe you will have to configure a bit. let me know if any issues 🙂

Distribution.xlsx

Distribution.yxmd

mi_schmidt · Answer

Hi @Raj_Singh1 ,

Thanks for taking the time to go through the post.

There is no designated input colum, see it as distribution similar to the normal distribution for example. A value (column Name) should be generate based on the frequency stated in colum Bin. (The colum total is the summed up frequency of colum bin).

When I generated e.g. 10000 values of Name, the distribution should again look similar like the plot attached.

I hope that helps.

Thanks

Michael