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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
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

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

hi a simple transpose tool will work here.

 

PFA the workflow

 

cheers

Labels