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