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% |
Can you expand upon your logic for how you're calculating subsequent values? This can be achieved with the generate rows tool.
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.
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% |
@AbdulBasit
Maybe this is what you need, distributing the 9446 rows of input per the percentage.
how do i generate a row containing number"1" hundred times number "2" also hundred times and every number till 9 hundred times.
@AbdulBasit
Two generate Rows Tools
and if i want to generate number "1" 3460 times and number"2" 1700 times
@AbdulBasit
Dude, try to check my first workflow and appreciate your accept mark if this helps.😁