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.
@stj1120 what is the expected output?
@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.