Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Server Discussions

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

Writing data into multiple sheets of same excel output file

RAMN
Astéroïde

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

1 RÉPONSE 1
jamielaird
Magnétar

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