Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Excel Pivot Question

psameer2706
5 - Atom
‎11-02-2021 02:39 AM

Hi All, 

 

Can anyone advise how to create the pivot as in excel via Alteryx?

Been trying lot of variations but cant get through this.

 

Regards,

Sameer

Preview file
130 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
ChrisTX
15 - Aurora
‎11-02-2021 03:37 AM

Please provide input data.

 

Reply
0 Likes
Christina_H
14 - Magnetar
‎11-02-2021 05:20 AM

It depends on the layout of your input data, but here's an example.  You might need to use a cross-tab tool if you want a field to appear as columns.

Christina_Hurrell_0-1635855611841.png

 

Pivot.yxmd
Reply
0 Likes
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels