Output in same file from two models breaks pivot

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

Output

Accepted answers

Kucsi

Hi,

try to use a blank excel. It is strange, but not an alteryx problem, but an excel. Make a new template and write into it. Do you have one workflow for the two dataset or do you write it separetly? If you do it in one workflow add a parallel block until done tool to your workflow. I can attach a sample on afternoon.

Thanks,

Kucsi

All comments

Kucsi

Hi,

Can you attach a dummy excel?

I had a quite similar process, where all i need is to refresh the pivot table in the output file (I do it with vba script).

Waiting for the file 🙂

Thanks,

Kucsi

Kdeshmukh

Hi Kucsi,

Please find the attached dummy excel, the tab 'Back-up working' has all the pivots, which are based on tab 'Mat Grp Data_2019_Backup' (alteryx output)

Rest all tabs are alteryx output, '2019' data from one model and '2018' from another model.

So, the problem i am facing is , if i ran 2019 alteryx model first, pivots are intact, But after that i have to run 2018 model for that year's data, which then breaks the pivot, even though it is based on 2019 data.

Thank you!

Regards,

Ketki

Sample_file.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703