In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Comma separated values into the new Rows

GouthamVijay
7 - Meteor

Hey Folks,

 

Whenever there are values which is separated from the comma then it has to be entered in the next row...

 

Input:

 

GouthamVijay_0-1654841870024.png

 

Expected Output:

GouthamVijay_1-1654841903897.png

 

 

Regards And Thank You

4 REPLIES 4
PhilipMannering
16 - Nebula
16 - Nebula

Check out the Text to Columns Tool. There's an option to split to rows.

messi007
15 - Aurora
15 - Aurora

@GouthamVijay,

 

Please see below :

 

Text tocolumn with Split to rows : 

messi007_0-1654845191764.png

 

Data cleansing to remove leading white space.

messi007_1-1654845270165.png

 

Attached the workflow,

Regards,

 

flying008
15 - Aurora

Hi, @GouthamVijay 

 

So easy please see that below:

 

录制_2022_06_11_14_00_00_553.gif

ddiesel
13 - Pulsar
13 - Pulsar

Hi @flying008!

 

Love that you responded with a gif! I never considered doing so, but this brings the solution to life!

Labels
Top Solution Authors