Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

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