Assigning Random Number to a Data Set to Form Even Pots

Pav007

Hi, 

I am struggling to assign a randomly generated number as a separate column to my data set in such a way that it would give me even splits as a final output. 

For example, I have 900 rows in my data set and would like to randomly assign numbers between 0 and 8 to it as a separate column so my final output will be 

0 = 100 rows

1 = 100 rows

2 = 100 rows

3 = 100 rows

4 = 100 rows

5 = 100 rows

6 = 100 rows

7 = 100 rows

8 = 100 rows

 

I was able to add random numbers to my data set as a separate column using RandInt(8) function , however the final outputs are not 100 rows per number - it varies between 98 and 134 rows. RandInt(8)Splits per Number

 Apologies if this is a dumb question.

Many thanks,

Pav

JoeS

James' solution is neat and nicely dynamic.

If you wanted something a little more simple you could also look to use the rand function along with a sort and tile tool in equal records mode.

Random.yxmd