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

Output in same file from two models breaks pivot

Kdeshmukh
7 - Meteor

Hi , 

 

I am using two alteryx models, which give output in same excel file, in different sheets. These models are for yearly data, one is for 2019 and another for 2018.

 

The output (Excel) file also has pivots based on output from 2019 data (Model).

The pivots breaks (pasted values) whenever second model is ran and output sheets are created in it.

While opening the file i get an error " Error, multiple attempts to open the file"

 

Currently as a way out i am getting 2018 data in separate excel file and then moving those sheets in the final file.

 

If anyone can help that will be great!!!!

 

Thanks and Regards 

   

 

 

11 REPLIES 11
Kdeshmukh
7 - Meteor

Hi Kucsi,

 

Thanks a lot for your suggestions, i don't know how but now Excel is working fine.(Guess excel has its own way :P) 

So, basically i am able to run the Alteryx model and the Pivots are intact!!!

 

your suggestions : 1. To start with fresh Excel File and 2. To combine the models and get output through one model were of great help!!

 

You have saved me tons of time and frustration 🙂

 

Thanks once again!!

 

Regards,

Ketki 

Kucsi
8 - Asteroid

Hi Ketki,

 

glad to hear it! 🙂 

 

Always happy to help.

 

Thanks,

Kucsi

Labels