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.

Pivot table breaking in alteryx output

Pandey19
8 - Asteroid

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.

6 REPLIES 6
pdave87
11 - Bolide

hi,

 

Can I take a look at sample data? Both input and output result from your execution? We have option to create output in excel file however, just to make sure if I understand correctly I want to check your files.

 

Regards,

Pratik

patrick_mcauliffe
14 - Magnetar
14 - Magnetar

Hey @Pandey19  can you post the workflow with dummy data?

Pandey19
8 - Asteroid

This is what i'm doing it. In output tool, create new sheet and then using Take file/table name option 

Pandey19_0-1632311434103.png

Pandey19_1-1632311462069.png

 

It should save the output in already existing file where i've my pivot table as Sheet1. 

What's happening is that everytime i run the workflow it will disturb the pivot .I cannot use that as a pivot table. Rather its coming as normal rows & column.

I want to retain my pivot table and in addition keep in adding new output as new sheet in same excel.

 

I've attached one sample excel here where i've my base table and it's pivot and i want to paste output in same sheet but in different tabs without disturbing pivot.

 

mceleavey
17 - Castor
17 - Castor

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.



Bulien

Pandey19
8 - Asteroid

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.

BRomat
5 - Atom

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. :)

 

 

Labels