Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Convert selected columns based on delimiters into rows

ArnabSengupta
8 - Asteroid

Hi All,

 

I have have a dataset as follows:

 

SL NO.DateProduct
1216-NovW46
1317-NovED76 // W5//W46
1418-NovEF455

 

I want convert the product specific columns into rows using the delimiter :

 

Output:

 

SL NODateProduct
1216-NovW46
1317-NovED76 
1317-Nov W5
1317-NovW46
1418-NovEF455

 

Help is much appreciated.

 

Thank you!

1 REPLY 1
Aaron_Harter
11 - Bolide

Hi @ArnabSengupta

 

Check out the 'split to rows' functionality of the Text to Columns tool:

1.PNG 

Labels