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