Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

generate rows

AbdulBasit
8 - Asteroid

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.

130.1%
 
217.6%
 
312.5%
 
49.7%
 
57.9%
 
66.7%
 
75.8%
 
85.1%
 
94.6%
8 REPLIES 8
echuong1
Alteryx Alumni (Retired)

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

AbdulBasit
8 - Asteroid

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
Alteryx Alumni (Retired)

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? 

 

        

130.10%
217.60%
312.50%
49.70%
57.90%
66.70%
75.80%
85.10%
94.60%
10 
1130.10%
1217.60%
1312.50%
149.70%
157.90%
166.70%
175.80%
185.10%
194.60%
20 
2130.10%
2217.60%
2312.50%
Qiu
20 - Arcturus
20 - Arcturus

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

1020-AbdulBasit.PNG

AbdulBasit
8 - Asteroid

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

Qiu
20 - Arcturus
20 - Arcturus

@AbdulBasit 
Two generate Rows Tools

1020-AbdulBasit-1.PNG

AbdulBasit
8 - Asteroid

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

Qiu
20 - Arcturus
20 - Arcturus

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

Labels