Unable to Create Backup - Block Until Done

I'm currently trying to write 4 different tabs into 1 excel workbook. I've been using the Block Until Done tool in order to make sure the first output to excel is done before the 2nd output and etc. However, I still continue to get the error of Unable to create backup. I've tried to use some other recommendations such as parallel block until done but the same error appears. This is something our organization is hoping to eventually put on the server so other people we can run this but I need to get this error resolved first. To me, it doesn't seem like the Block Until Done tool is working properly unless I'm missing something.

Thanks,

Andy

2021-02-26_13-05-49.png

Workflow

Accepted answers

All comments

Emil_Kos

Hi @Nerud19,

Maybe you can use reporting tools. Please check this post by @CharlieS:

The workflow from this post will show you how to do it:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multiple-Reporting-tool-outputs-to-one-excel/m-p/482211/highlight/true#M97301

patrick_digan

@Nerud19 We were having similar issues and developed a simple batch macro. We've even brought a couple settings into the macro so you can toggle some options (deleting the file, preserving the formatting and skip field names).

You do need to just have a dummy text input with only one record connected the initial upside question mark. Then You can just chain together as many of these macros as you want.

This works because the initial dummy record is passed through the B output and you connect it to next macro's question mark. batch macros have to be completely done before they send the output, so it works if you connect these sequentially. We did have to add a wait macro between these at one point when we determined that excel was taking too long to close and still producing an error.

Excel Output ordering.yxmc

Sample workflow.yxmd

CharlieS

If it's a timng/delay issue, maybe adding a Throttle tool behind the Block Until Done might help getting that timing to work?

https://help.alteryx.com/current/designer/throttle-tool

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703