Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO MyAlteryx
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
16 - Nebula
16 - Nebula
‎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
register for inspire
designer new user guide
Labels
Top Solution Authors
View All