How to pass variables to Pivot Table

[Kuha]

Hi,

I am creating a pivot table using this process.

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

[martinding]

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]

Hi,

I have attached a sample file as you requested.

Kuha

[RobertOdera]

Hi, @Kuha 

What do you need to iterate on?

Region or Rep or both?

Thanks!

[Kuha]

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]

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]

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]

Hi @Kuha ,

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

Please see attached:

[Kuha]

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

[martinding]

Hi @Kuha 

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