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.

How can I pivot this data set with two layers?

alteryxisconfusing
8 - Asteroid

I'm currently using cross tab, tables, and render tools in my workflow, but I can't figure out how to manipulate this data set into a pivot. 

 

Attached are the raw input file and below is an image of the desired output I am trying to achieve. 

 

Desired Pivot - Copy.png

 

 

7 REPLIES 7
binuacs
20 - Arcturus
Felipe_Ribeir0
16 - Nebula

Hi @alteryxisconfusing 

 

 

One way of doing this

Felipe_Ribeir0_0-1665782827971.png

 

alteryxisconfusing
8 - Asteroid

Is it possible to have it displayed in the Output in this manner? I don't need the row/column totals like in the image, just the data grouped accordingly by student name and then showing their associated class cost and expense. So it should output kind of like this:

 

Student NameCost TypeBiologyChemistryHistoryPhysics
Ashley     
 (blank)  0.01 
Frank     
 Class Cost866 705963
 Expense  232197
George     
 Class Cost579681983933
 Expense  201189
alteryxisconfusing
8 - Asteroid

Is it possible to have it displayed in the Output in this manner? I don't need the row/column totals like in the image, just the data grouped accordingly by student name and then showing their associated class cost and expense. So it should output kind of like this:              

 

Student NameCost TypeBiologyChemistryHistoryPhysics
Ashley     
 (blank)  0.01 
Frank     
 Class Cost866 705963
 Expense  232197
George     
 Class Cost579681983933
 Expense  201189
Felipe_Ribeir0
16 - Nebula

Hi @alteryxisconfusing 

 

Please take a look at the attached version.

 

Felipe_Ribeir0_0-1665919638127.png

 

alteryxisconfusing
8 - Asteroid

Thank you so much, it works, is it possible to also pivot it to look like this?

 

alteryxisconfusing_0-1665991346865.png

 

Felipe_Ribeir0
16 - Nebula

Hi @alteryxisconfusing 

 

Please take a look at the attached version.

 

Felipe_Ribeir0_0-1666004204979.png

 

 

 

Labels