Alteryx Designer Desktop Discussions

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

How to pass variables to Pivot Table

Kuha
7 - Meteor

Hi,

 

I am creating a pivot table using this process.

Kuha_0-1680339548080.png

I have to create about 20 pivot tables. Is it possible to pass the info required for the 'Cross Tab' from a text file using micro, So I don't need to create 20 processes?

 

I am new to Alteryx and not familiar with micro. Any suggestions would be a great help. Thanks.

 

Kuha

 

14 REPLIES 14
martinding
13 - Pulsar

Hi @Kuha,

 

You can certainly build a Macro to help you automate this process.

 

Would you be able to provide a sample data set and your desired output so that we can better understand your use case?

 

Kuha
7 - Meteor

Hi,

 

I have attached a sample file as you requested.

 

Kuha

RobertOdera
13 - Pulsar

Hi, @Kuha 

 

What do you need to iterate on?

Region or Rep or both?

Thanks!

Kuha
7 - Meteor

Hi @RobertOdera ,

 

Sorry, I forgot to add the report ID. Iteration is on Report_ID. I have attached the updated sample file. Thanks.

 

Kuha

RobertOdera
13 - Pulsar

Sure thing, @Kuha 

 

I'm on track to look at this tomorrow evening or Monday morning.

 

Tagging @martinding in the case can give you an impact asap, otherwise, I'm sure someone in the community will ping you - Cheers!

martinding
13 - Pulsar

Hi @Kuha,

 

Would you be able to shed some light on how the "Filter" works?

 

Are you trying to select a particular Field in each report? e.g. for Report-01, do you only want the region field? or are you selecting a particular value of region? e.g. you want the region to be east?

martinding_0-1680386951536.png

 

martinding
13 - Pulsar

Hi @Kuha ,

 

I've taken the "Region to be east" path and added an extra column for the control parameter.

martinding_0-1680389806466.png

 

 

Please see attached:

martinding_0-1680389503354.png

Kuha
7 - Meteor

Hi @martinding ,

 

I just want the region field. See the screen print below.

 

Report-01 will save the pivoted result to excel File1

Report-02 will save the pivoted result to excel File2 so on

 

Kuha_0-1680396618263.png

 

Kuha_1-1680396785601.png

 

 

 

martinding
13 - Pulsar

Hi @Kuha 

 

So do you mean that the "Filter" field is not actually a filter, but is actually used as a Group By?

Labels