Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Transpose Data

HW3
7 - Meteor

Hello,

 

I wanted to ask if there is a way to change Table 1 into Table 2. I tried using the cross tab tool, but it is aggregating the values instead of displaying the values.

 

HW3_0-1686348649745.png   

HW3_1-1686348688654.png

 

 

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@HW3 
This will be my favorite tool "Tile" with a CrossTab.

0610-HW3.PNG

nagakavyasri
12 - Quasar

Your output:

Screenshot 2023-06-12 145616.png

HW3
7 - Meteor

Hi Qiu,

 

Thank you for providing this solution. I did get it to work. I'm not sure if I could truly explain how or why it works, but I did get it to work. I'm going to go back and review the functions again to get a better understanding.

HW3
7 - Meteor

Hi Nagakavyasri,

 

Thank you for your suggestion. I'm going to try this approach also to see if I can get it to work.

Labels