Splitting into Multiple rows

[Vsridharan]

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

[alexnajm · Accepted solution]

I would look at the Split to Rows option of the Text to Columns tool, then use a regular Formula to form the new field!

[Vsridharan]

@alexnajm, Incase I need to merge it back after I made some small changes, how would you recommend that I go about it?

[alexnajm]

Really depends on what you are looking for, but you could probably Join it back based on the Unique ID!