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.

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