community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Generate Rows

Meteoroid

Dear all, 

 

I would like to generate rows based on a figure in a table. 

 

On-timeall
45
24

 

The end product should look like that:

on-timeall
11
11
11
11
01
11
11
01
01

 

Do you have any idea for me?

 

Many thanks in advance!

I suggest the attached.

 

2017-12-06_09-46-17.png

 

Generate rows for the all columm

Then use a formula tool to adjust the on-time to be 1/0 

Finally another formula to change all to 1

 

 

Highlighted
Asteroid

Hi Jo-B,

 

Try this workflow, hope it helps.

 

Thanks,

 

Michael

Meteoroid

Dear Both!

 

Thanks for the quick help! Really appreciated the great support! :-)

Labels