How to parse comma separated values in multiple columns to same row

[lynnlinnewtoalteryx]

Hello, 

New to alteryx. Thank you for anyone who answers me in advance!

I have data like this:

Col 1	Col 2	Col 3	Col 4
1	a,b	3	h/g
2	c	4	m
3	d,e,f	3	d/m/u

Expected output like this:

Col 1	Col 2	Col 3	Col 4
1	a	3	h
1	b	3	g
2	c	4	m
3	d	3	d
3	e	3	m
3	f	3	u

Lynn

[ArtApa · Accepted solution]

Hi @lynnlinnewtoalteryx - Here is how you can solve it:

[atcodedog05 · Accepted solution]

Hi @lynnlinnewtoalteryx 

Just as a knowledge share here is an additional way using multi-row formula tool. Tile tool approach is definitely the easier and suggested one for this usecase.

Hope this helps : )

[lynnlinnewtoalteryx]

Thank you! It worked well~

[lynnlinnewtoalteryx]

Thank you, this worked as well!

[atcodedog05]

Happy to help : ) @lynnlinnewtoalteryx 

Cheers and have a nice day!

[suby]

Hi atcodedog,

Could you please explain what this expression does on this use case scenario.

[Row-1:SubId]+1

[atcodedog05]

Hi @suby 

Refer the highlights.

I am setting groupby Col 1 and value doesnt exist as 0. Which means of each group of Col 1 it starts with 0 and gets added up on each occurence.