Pivot table breaking in alteryx output

Question

Hi,

I've one sheet where in i've my pivot table. Now i'm trying to output many tabs in same excel sheet.

Every time i run the workflow it will break the pivot table that means i'm losing the pivots and getting a normal rows & columns.

I cannot refresh or do any pivot thing there.

Anyone can help me why is this happening?

I just want all my output in same excel sheet with different tabs where i've my pivot table.

BRomat · Answer

Hey y'all. After a lot of trial and error, here is my solution if anyone is still in need. The workflow I'm currently doing is huge, so I'm not going to attach an example. But essentially, instead of basing your table off of a "Table" in Excel, update it to a "range" (Think $A:$X, not $A$2:$X$500 unless your # of rows stays consistent).

Overwriting the sheet shouldn't impact the pivot table. :)

Pandey19 · Answer

Thing is we are not allowed to use macros. Strange rule here.

My only concern is why i'm losing the pivot table everytime i'm creating new tab in my ouput?

i just want pivot table to be as it is and create new sheet in same excel.

mceleavey · Answer

Hi @Pandey19 ,

to be sure we'll need all the information. You've created a field called Deal Name, and are replacing the entire filepath, which means that field needs to contain the entire file path, not just the name.

Also, given you are trying to write out to multiple sheets in the same file you'll need to wrap it in a batch macro (just the output tool) and feed in the grouped Deal Name field as a control parameter. This prevents Alteryx from attempting to write out to the same file simultaneously.

M.