community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Transforming a column to a row

Alteryx Partner

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, 

 

ACE Emeritus
ACE Emeritus

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

Highlighted
ACE Emeritus
ACE Emeritus

Hey there!

Attached is a sample!

 

Thanks!

Jack

Alteryx Certified Partner
Alteryx Certified Partner

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

Alteryx Partner

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

 

Best, 

Han

Labels