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

Unable to select column in Table tool after selecting pivot radio button

george317
7 - Meteor

Hi,

 

In my below workflow I wanted to use pivot in the Table tool and wanted to group the data on basis of region but I'm astonished that I'm unable to see any column here to select/to change according to my need. Is this something happening only to me, I even tried with other excel files and still unable to see any column here when selecting Pivot radio button inside Table tool. Though the other radio button "Basic" works absolutely fine. Wanted to know if I'm missing out anything

 

 

george317_0-1590590702948.png

george317_1-1590590822246.png

 

4 REPLIES 4
RobertOdera
13 - Pulsar

Hi, @george317 

 

Please marks as an acceptable solution and like, if this works for you.

 

Looks like you might need some pre-steps before the Reporting Tools.

1. Summarize: Group by Employee, Group by Region, Sum Sales as Total_Sales

2. Cross Tab: Group by Employee, Column Headers = Region, Values for New Columns = Total_Sales, Method = Sum

 

And then, you can add the Reporting Tools (in this case, Table configured to Pivot per below)

**You can also check out the basic table examples in Alteryx (click on the basic table, then click on Open Example) to try the other pivoting styles and see which one works for you 🙂

 

Table Config

RNO2_0-1590592872183.png

 

Solution

RNO2_1-1590592923900.png

Workflow

RNO2_2-1590592981736.png

 

Cheers!

george317
7 - Meteor

HI @RobertOdera ,

 

Thank You for the solution and it worked as you mentioned, but after completion I'm here with new doubt. After viewing the solution I'm right now thinking whether it is necessary to make Summarize and Cross tab tool before checking Pivot button in Reporting Table tool, every time. If so then what exactly is the use of this Pivot button in Table tool. 

 

God bless for helping and taking out time for me. Thank you.

RobertOdera
13 - Pulsar

Hi, @george317 

 

Sure, it's good practice to Challenge (and very refreshing!).

 

IMHO, I don't think that you have to use the Summarize Tool every time.

My best understanding of how to get you to your desired outcome led me to use Summarize as part of the process before the Cross Tab Tool.

 

Based on the examination of open examples and reflecting on my experiences to date, in order to create a pivot table using the Table Tool, you MUST Cross Tab Tool the data and then stream it (connect) into the Table Tool to further process according to your selected pivot style option.

 

Kindly check out these links to see how others are approaching the challenge. I hope you find them helpful!

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-pivot-table-with-filters-like...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-pivot-table-in-Alteryx/td-p/432...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Pivot-Table-with-Alteryx/td-p/176018

 

Cheers!

 

 

 

 

george317
7 - Meteor

Thank You....That was great indeed..

 

 

Have a great day. Thanks a lot once again.

Labels