Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Transforming a column to a row

hanswang09
6 - Meteoroid

Hi, 

I have a simple question on transforming the data. This is the input format. 

Customer ID DateProduct 
111/16/2015A
111/16/2015B
111/16/2015C
111/16/2015D
111/16/2015E
111/16/2015E
111/16/2015F

 

And I want to transform/transpose SKU from a column to a row, which will look like this. 

Customer DateProduct 1Product 2Product 3Product 4Product 5Product 6
111/16/2015ABCDEF

 

I am not so familiar with transpose functions so any help is much appreciated. 

 

Thanks, 

 

4 REPLIES 4
pcatterson
11 - Bolide

The thing you need is a Cross Tab tool to accomplish this.

jack_morgan
9 - Comet

Hey there!

Attached is a sample!

 

Thanks!

Jack

danielbrun2
ACE Emeritus
ACE Emeritus

Hi,

 

I am not quite sure what you are trying to achieve, but the attached workflow might point you in the rigtht direction.

 

I think what you are looking for is crosstab and not transpose.

 

Best,

Daniel

hanswang09
6 - Meteoroid

Thank you very much for all your help. It works great. 

 

Best, 

Han

Labels