community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

Need Help with Pivot Tables

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

Magnetar
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!

Highlighted

hi a simple transpose tool will work here.

 

PFA the workflow

 

cheers

Labels