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
20 - Arcturus

@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