Use variable to generate data

Yury_Brunt

Hi,

Please see my example attached. I need to generate some sample data for simulation purposes.

With the multi row tool ID's are added to the data (see comment in workflow), this is bases on a fixed number of rows, the next step is to group them

I need the number of row's to be variable. Let's say between 1 and 10. 

Is there any way to do that?

Thanks,

Yury

Data_generation_20180731.yxmd

CharlieS

@Yury_Brunt

In a Formula tool I used the RandInt( function to produce a random group size, then generated rows for each group. This is highly likely to produce a list of group assignments larger than the records, but I just used a position-based Join to used the necessary group assignments back to the original.

Solution attached.

20180731-RandomGroupSize.yxmd