Alteryx designer Discussions

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

Generate Rows

Highlighted
6 - Meteoroid

Hoping for assistance on a formula to generate additional rows to align all TBC columns and their multiplier as seen in the attached excel examples.

 

Starting Data

lbrehmer_0-1582069609067.png

 

Desired Outcome

lbrehmer_1-1582069643259.png

 

Highlighted
15 - Aurora

Here's one way of doing it

 

DavidP_0-1582071910048.png

 

Highlighted
6 - Meteoroid

Thank you very much for the quick reply!

Labels