If you want to write in multiple sheets in the same excel file, this is the blog for you!
You might have come across the issue of having 2 output files close together and when you're running the workflow, you get errors. This is because Alteryx will read the first output file into excel and when the second output file is trying to be read in, it will not work as the excel file is already opened.
As we can see above, we have 3 output tools in the same workflow.
To counteract this problem - the Block Until Done Tool
So how do we use this tool in our workflow?
Now both outputs will run. But what will happen if we want outputs before and after a filter tool.
That's when we use the parallel block until done tool. This tool needs to be downloaded.
The link to download the Parallel Block Until Done Tool.