Splitting columns

[ssubramanian]

Hi,

I have a requirement:

Input: 

Segment	LB	Dept
S1,S2	L1	D1,D2,D3
S2,S3	L2,L3	D4

Output: 

Segment	LB	Dept
S1	L1	D1
S1	L1	D2
S1	L1	D3
S2	L1	D1
S2	L1	D2
S2	L1	D3
S2	L2	D4
S2	L3	D4
S3	L2	D4
S3	L3	D4

This is just an example I have 7 such columns with different combinations. Right now I am using text to column tool for each of the 7 columns (7 Text to Column tools). Is there a way to do this in fewer steps?

[DavidP]

Yo can use the split to rows option in the Text to columns tool

[ssubramanian]

Attaching the workflow I am using. Please suggest a more efficient method.

[ssubramanian]

Hi @DavidP,

Thank you for the solution. I am currently using this method. Could you please suggest another method with fewer steps as the workflow would be lengthy with the increase in number of columns.

[DavidP]

I had to sleep on it a bit.

Here's an iterative macro that can solve the problem for a number of columns.

[ssubramanian]

Hi @DavidP,

Thank you so much for spending time on this. Unfortunately, I am unable to load the workflow as I am using an older version of Alteryx. I am re-creating the entire workflow in my Alteryx Designer. I will let you know once I execute it.

Thanks again!

[DavidP]

Have you seen this app from Marquee Crew on the Alteryx Gallery? It converts Alteryx workflows to older versions:

https://gallery.alteryx.com/#!app/Modify-Alteryx-Workflow-Version/5773f9c33df7da0e58dc82d3

[DavidP]

Which version of Designer are you using?

[ssubramanian]

That's awesome. I will try it out. Thank you @DavidP

[ssubramanian]

I am using "2018.2.4.47804" Version.