Free Trial

Alteryx Designer Desktop Discussions

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

split multiple columns with the concatenated values into rows in alteryx

stj1120
8 - Asteroid

Hi all,

 

The dataset has 9 columns, but the values ​​in each column are separated by a comma (,). How can I select all the columns at once and extract the concatenated values ​​to split them into rows in Alteryx without using Text to columns tool multiple times? 

 

Can we use muti field formula tool and acheive the desired result? Please advice.

 

Thanks & regards,

stj.

 

3 REPLIES 3
binuacs
21 - Polaris

@stj1120  what is the expected output?

CoG
14 - Magnetar

@binuacs is absolutely right.

 

One of the complicating factors in your input data is that different columns have different numbers of comma separated elements, leading to the question how should an element from one column be related to elements from other columns?

 

The easiest first step would be to Transpose before using the Text to Columns Tool, but what you do after that depends on what your target output is.

flying008
15 - Aurora

Hi, @stj1120 

 

Could you please upload data table as your want output ?

Labels
Top Solution Authors