Have you ever tried writing to multiple tabs within the same workflow and have received an error like this:
“Error: Output Data: Unable to open file for write: FULL_FILE_PATH.xlsx Error Opening file: FULL_FILE_PATH.xlsx: The process cannot access the file because it is being used by another process.”?
This is occurring because Excel, like many applications, will get confused if multiple processes are happening to it at once which is why you can’t have the same excel file open while you are reading it in to Alteryx. To avoid simultaneous writing, there is an awesome tool called the Block Until Done Tool which will prevent this.
The Block Until done tool will wait until all processes upstream are finished before sending work downstream. This tool has three outputs. What is useful about it to us in this case is each output will be processed in sequential order. To illustrate:
This will always error out because the output tools in Alteryx are being used at the same time thus Excel will get confused.
In contrast this will always work because the second stream will not kick off until the first stream is finished.
So all youhave to do when writing to the same file but different tabs is make sure youuse a Block Until Done to prevent it from writing to the excel file simultaneously.
For more information on the Block Until Done Tool click here.