Alteryx designer Discussions

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

Need Help: Split One Row into Multiple Rows

Highlighted
7 - Meteor

In my daily work, I need convert one spread sheet like below into different format, please help show me how to do it in Alteryx. 

Origin1.jpg

 

Convert to 

2.jpg

Thanks a lot

Highlighted
Alteryx Certified Partner

Hey @zhuyyu

 

Something like this should to the trick!

Convert.PNG

 

Highlighted
14 - Magnetar
14 - Magnetar

Hey @zhuyyu!

 

There is probably a more efficient way to accomplish this, but I was able to achieve your output with the attached workflow.

 

Hope this helps!

Highlighted
7 - Meteor

Thank you so much, I tried myself, almost got there, adding ID is what I missed, now works like a charm. Thanks again.

Highlighted
7 - Meteor

Thank you too, I tried both, Neil's way is a little bit better and straight forward to read. Thanks again.

Labels