We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Mutli Row Dynamic Id and Loop

unkownreiver
5 - Atom

Hi, If anyone could help, I am new and not able to come up how write specifics to generate desired output on attached example Thanks URmultirow.PNG

3 REPLIES 3
KarolinaRoza
11 - Bolide

Hi @unkownreiver ,

 

Please find attached workflow with Multi-Row Formula which I hope solve your problem.

 

EDIT: Actually I came up with faster solution, so I added it to attached workflow (now, there are two).

 

Regards,

Karolina

 

KarolinaRoza_0-1624745174366.png

 

Qiu
21 - Polaris
21 - Polaris

@unkownreiver 

Not so pretty but I hope it will work for you.

Capture1A.PNG

unkownreiver
5 - Atom

Thank you Qiu and Karolina. Both solution produce the desired result. Second solution by Karolina is further shortest and fastest. Thanks UR

Labels
Top Solution Authors