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

[danrh]

Something like the attached?  Each time this is run, it will produce a random number from 1 to 10, and the grouping will be based on that value.

[CharlieS · Accepted solution]

@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.

[CharlieS]

EDIT: Removed.

[Yury_Brunt]

Thanks @CharlieS, nice solution think this can do the trick.

[Yury_Brunt]

Thanks @Quasar, but i needed the individual groups to be variable from size.

[danrh]

Ah, I gotcha.  I thought you were saying a random size of group, but each group the same size.

For the sake of giving multiple options, so here's another solution to go along with @CharlieS's.  Wanted to see if I could get it all in a single stream :)

[CharlieS]

Very nice solution, @danrh!