Split Rows based on row values from 2 columns and match

[David-teryx]

Hi All, 

I have to generate a row for each ProductName with its own ProductValue but couldn´t figure out how it can be done.

My input looks like this

CompanyName	ProductName	ProductValue
Company1	ABC,CDE,FGH	RG?,1XE,HS8
Company2	X7-8	RT,UV
Company3	R2,A4-5,B1-3	15D5?T

Now, the desired output should look like this

CompanyName	ProductName	ProductValue
Company1	ABC	R
Company1	CDE	G
Company1	FGH	?
Company1	ABC	1
Company1	CDE	X
Company1	FGH	E
Company1	ABC	H
Company1	CDE	S
Company1	FGH	8
Company2	X7	R
Company2	X8	T
Company2	X7	U
Company2	X8	V
Company3	R2	1
Company3	A4	5
Company3	A5	D
Company3	B1	5
Company3	B2	?
Company3	B3	T

Please help! 🙂

[Aaron_Harter]

Hi @David-teryx, 

You'll want to break the names & values into separate streams, parse them into the desired shape, then use the Tile tool to assign the proper location for each data point relative to the original starting position:

 

[atcodedog05 · Accepted solution]

Hi @David-teryx 

Here is my approach to the task.

Input: table given by you

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[grazitti_sapna · Accepted solution]

Hi @David-teryx , give this a try.

Thanks.

[atcodedog05]

Great usecase

Happy to help 🙂 @David-teryx 

Cheers and Happy Analysing 😀