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.
SOLVED

Need Help with Pivot Tables

mham
6 - Meteoroid

Looking to make my data more manageable for a Tableau pull through and am looking to do a pivot like the example below. Not sure how to do this, if anyone could provide screenshots on how I can do it with the settings inside the tools that would be awesome! I know others use the transpose tools, but they are not providing the steps within the tool. Thank you, screenshots are below and an attachment is also provided. The 1st picture is my current data, the second is the want.

image.pngimage.png

2 REPLIES 2
Claje
14 - Magnetar

Hi,


Try using a Transpose tool, with Name and Person as Key fields, and see if that gets you close to what you need!

Chandler_Bing
8 - Asteroid

hi a simple transpose tool will work here.

 

PFA the workflow

 

cheers

Labels