We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Convert Pivot Table back

Inactive User
Not applicable

Hey guys, 

 

I currently have a problem to transpose my pivot table back to a "normal" (I don't know what it technically called) database. My database looks like below 

pietapa_0-1671549206001.png

But I would like to have the database like this below.

pietapa_1-1671549322518.png

I tried it with the Transpose-Tool but it does not work very well.... I don't know what I did wrong and where my mistake was. 
Can you help me? 

Thank you :) 

4 REPLIES 4
gautiergodard
13 - Pulsar

Hey @Inactive User 

Is this what you are looking for?

Attaching the workflow for your reference.

gautiergodard_0-1671549823338.png

 

binuacs
21 - Polaris

@Inactive User One way of doing this

binuacs_0-1671552807064.png

 

Inactive User
Not applicable

Thank you @gautiergodard @binuacs 
Yes that is what I was looking for. I don't know why I am so incompetent :D 

gautiergodard
13 - Pulsar

@Inactive User Not incompetent at all! All part of the learning process.

Kindly accept the solutions here to help others find answers more effectively in the future!

Labels
Top Solution Authors