Alteryx Designer Discussions

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

Create a two row header and pivot remaining data

Kay327
6 - Meteoroid

Hello,

 

I am trying to pivot my data, but I need two columns to be used as the header.

 

Kay327_1-1623437968527.png

I would like to pivot the data based on the city and the car type.

 

Thank you.

3 REPLIES 3
ArtApa
Alteryx
Alteryx

Hi @Kay327 - Here is what you can do:

ArtApa_0-1623475587419.png

 

Kay327
6 - Meteoroid

@ArtApa Thank you for all of your help!!

john_watkins
9 - Comet

Here is just another way to look at it with one additional cosmetic tweak.   I am finding it useful in Alteryx lately to start by building the matrix of what I expect to come out at the end.  Then I simply join my various inputs back to that as my master list of combinations.  In your case, you find not each origin has all car types.

Labels