generate rows

[AbdulBasit]

i have 9446 records and i want to generate a row contanining 30.1% number 1 , 17.6% number 2 and 12.5% number 3. and rest are following how do i do it.

1	30.1%
2	17.6%
3	12.5%
4	9.7%
5	7.9%
6	6.7%
7	5.8%
8	5.1%
9	4.6%

[echuong1]

Can you expand upon your logic for how you're calculating subsequent values? This can be achieved with the generate rows tool.

[AbdulBasit]

of any given amount  row should contain 30.1%  number "1" and so described.

Can you tell me how to do this with generate rows tool.

[echuong1]

I'm not sure I understand what you're looking for still...

Would it look something like this for subsequent values? Are you able to provide more examples? 

1	30.10%
2	17.60%
3	12.50%
4	9.70%
5	7.90%
6	6.70%
7	5.80%
8	5.10%
9	4.60%
10
11	30.10%
12	17.60%
13	12.50%
14	9.70%
15	7.90%
16	6.70%
17	5.80%
18	5.10%
19	4.60%
20
21	30.10%
22	17.60%
23	12.50%

[Qiu]

@AbdulBasit 
Maybe this is what you need, distributing the 9446 rows of input per the percentage.

[AbdulBasit]

how do i generate a row containing number"1" hundred times number "2" also hundred times and every number till 9 hundred times.

[Qiu]

@AbdulBasit 
Two generate Rows Tools

[AbdulBasit]

and if i want to generate number "1" 3460 times and number"2" 1700 times

[Qiu]

@AbdulBasit 
Dude, try to check my first workflow and appreciate your accept mark if this helps.😁