Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Formula Help

Highlighted
11 - Bolide

Thanks in advance.  How do I turn one column into several by looking at a particular character, i.e. a comma.

 

Turn one column:

Lang

English, Spanish, Russian  (the number of languages in this one column could vary)

 

into many columns:

Lang1        Lang2         Lang3

English      Spanish      Russian

 

However, I may only need the first two but I guess if they could all be accounted for - that would be ideal.  Thanks for your help.

Highlighted
14 - Magnetar
14 - Magnetar

Hey @Brad1! In the Parse category in Alteryx, use the Text To Columns tool. Use Lang as your field to split and use a comma as the delimiter. Hope this helps!

Highlighted
11 - Bolide

Seems like u changed your picture.  Thanks for your help!

Labels