community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Writing data into multiple sheets of same excel output file

Highlighted
Meteor

Hi, 

I am looking for a solution to write multiple sheets into same excel file, that are coming from different sections in the workflow. Will alteryx throw any error if I use overwrite sheet option and use different output tools for different sheets.

 

For example, for 3 data sections in the workflow, I use 3 output tools with sheet1, sheet2, sheet3 of FILE1 and taken overwrite sheet option in the output settings.

 

Regards,

Ram

Alteryx Certified Partner

Hi @RAMN 

 

You will probably find that the 2nd and 3rd outputs return errors as the 1st output will have locked the Excel file while writing to it.

 

The easiest solution is to use a Block Until Done tool and structure your workflow so that your multiple Output tools are in streams that branch from different numbered outputs of this tool.

 

This approach is described here:

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-write-to-multiple-tabs-separately-wit...