Hi,
I am still learning Alteryx and am looking for some advice on how to split data into multiple rows based on a particular column.
From the attached file, the first table is the data that I have and am looking to split it to look like the output table.
It should basically duplicate the row x number of times (x being the number of different issues on column separated by coma).
Can I use the tile tool to create something like that, or is there an easier way to that?
Thanks,
V
Solved! Go to Solution.
@alexnajm, Incase I need to merge it back after I made some small changes, how would you recommend that I go about it?
Really depends on what you are looking for, but you could probably Join it back based on the Unique ID!