Output data not updating with latest data

Hi everyone,

I have created a workflow, and have connected four output data tools (linked to the same excel output file) to four streams. So in my excel output data file, there are five sheets, Sheet 1 (with no data) and the four sheets with the output data. However, the output file is not updated with the latest data when I run the workflow. I get a warning saying the sheet already exists. How do I get it to output the most up to date data in my workflow. Any help would be much appreciated!

Output

Accepted answers

JoeS

Hi @Chirag_Gandhi07

There is an option within the configuration of the output tool to set this behaviour.

By default when you chose an Excel file it is set to Create New Sheet, which means if it already exists you get the error you are seeing, it a bit of a safety feature to make sure you don't accidentally overwrite something you don't want to.

You can however change this setting, its option number 3 in the configuration window:

Overwrite Sheet (Drop) is the option you want in order to replace that one worksheet each time.

JoeS

You could look to do that, or use the block until done tool to co-ordinate the streams.

There is some useful advice in this post too:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Re-Output-to-multiple-sheets-within-an-Excel-file/td-p/11560

All comments

JoeS

Hi @Chirag_Gandhi07

There is an option within the configuration of the output tool to set this behaviour.

You can however change this setting, its option number 3 in the configuration window:

Overwrite Sheet (Drop) is the option you want in order to replace that one worksheet each time.

Chirag_Gandhi07

Thank you! It is working for two of the streams, but the other two give me a warning saying that the process cannot access the file because it is being used by another process. Should I consider connecting those two streams to a different excel output file?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703