Alteryx Designer

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

How to split a column into multiple columns?

Highlighted
6 - Meteoroid

I have a sample dataset like below and need help with an Alteryx workflow

 

Id               Product

 

123             a

123              b

123              c

124            a

124             b

 

How do I convert the above dataset to below?

 

Id                Product1         Product 2            Product3

123                   a                b                               c

124                   a                b

 

The # of products in each id can change eg some ids have only 1 , some 2, some 3 and so on...can it dynamically figure out the # of columns needed or do I have to give a maximum #?

 

Thanks

Highlighted
8 - Asteroid

HI @pachopra 

This might be something you would need.

 

Mark this as solution if it does solve ur issue.

Highlighted
9 - Comet

Hi,

 

Please see my solution attached. I used a combination of running total and crosstab tools to achieve the results.

 

Regards

Simha

 

Labels