Hi All,
I recently used Summarize > String > Concatenate option in Alteryx and with that, I concatenated multiple values separated by ","
Now i want to do the exact opposite based on the concatenated version, how best can I do it any suggestion
Example Initially i converted:
Text Values
xxx x1
xxx x2
xxx x3
xxw Y1
xxw Y2
to
Text Values
xxx x1,x2,x3
xxw Y1,Y2
Now i want to transform it back to original state:
from this:
Text Values
xxx x1,x2,x3
xxw Y1,Y2
to this:
xxx x1
xxx x2
xxx x3
xxw Y1
xxw Y2
How?
Solved! Go to Solution.
It worked, Cheers!