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

alteryx server Discussions

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

Writing data into multiple sheets of same excel output file

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