Start Free Trial

Alteryx Designer Desktop Discussions

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

Extract & Duplicate Row Data

kubikbr
6 - Meteoroid

In the attached workbook, I am trying to separate the paysource column if there are multiple values separated by commas and keep the rest of the columns the same.

 

In rows 1/2 I have the raw data. What I am trying to achieve is in rows 6-8. 

 

How would I achieve this in Alteryx? 

1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

Text to Columns tool will do the trick! Split that column based on the delimiter but Split to Rows will be the selection

Labels
Top Solution Authors