How to Write Multiple Excel Sheets in Alteryx

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.

Now the first flow that will be processed is from the false filter outcome and once that file has been outputted, then the second flow from the truth section will start. 

The link to download the Parallel Block Until Done Tool.

Author:
Maha Hussari
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab