Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

How to create a column starting from data in a column with separation

elfunambolo
8 - Asteroid

Hello,

The column's fields are composed of person's name after the first semi-column (see attached file, column A). I can have more than one person's names always separated by semi-column each one.

I want to create the "Owner's" column as column B,C,D filled by person's name present in column A.

Can you support me on it?

 

Thanks

Giovanni

1 REPLY 1
jdunkerley79
ACE Emeritus
ACE Emeritus

jdunkerley79_0-1605276410365.png

 

The Text to Columns tool will do what you need. Set the separator as ; and it will break up the CURRENT STEP into columns

 

You can then use a Select to lose the first column

Labels
Top Solution Authors