split multiple columns with the concatenated values into rows in alteryx

[stj1120]

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.

[binuacs]

@stj1120  what is the expected output?

[CoG]

@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]

Hi, @stj1120 

Could you please upload data table as your want output ?

[lwolfie]

Not sure if you figured this out, but here's an option to split them out without multiple text to columns.

[dreldrel]

You could consider text to column tool. This can help you to split the cells to either rows or columns