Block until done alternatives for optimizing the workflow

Question

Hi, I have around 15 tabs that I'm writing into the same excel from my workflow. How I do it right now to avoid the 'File already in use' error is I use stacks and stacks of block until done but this has made my workflow super slow as only after an entire data line is processed, it allows the next one to run and so on.

Is there a better way to do this?

caltang · Answer

Related posts:

* https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multiple-input-files-into-a-single-output-file/m-p/1199231#M297498 
* https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Saving-Multiple-Outputs-to-the-Same-Excel-File-in-One-Workflow/m-p/1196382#M296729

caltang · Answer

I had encountered this issue and raise a Support ticket because in my mind, the Block Until Done (BUD) tool isn't functioning as it should in our case.

Alteryx Support recommended me to put a delay before the output - and introduced some CReW macros from the marketplace as well as a solution.

In any case, I had a discussion here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Saving-Multiple-Outputs-to-the...

In that discussion, there three potential solutions for you. But if you are on v2023.1, I highly recommend using Control Containers. That will be much better than BUD for now.

If you are not v2023.1, you can consider my method by combining the data together and then split them. But the downside is that the data types are no longer preserved and are all forced to be strings.