Block Until Done Tool - Receiving Unable to Open File for Write Error

Mahendra1997

Dear Community,

I am a beginner in Alteryx and am facing difficulty in understanding why I continue to receive an error message, despite utilizing the "Block Until Done" tool for all the outputs that write to the same file (as shown in the screenshot below). When attempting to modify the placement of the "Block Until Done" tool within the workflow, then I'm getting multiple errors instead of one for other output tools that write to the same file.

I would greatly appreciate your help in resolving this issue. Attached is the workflow for reference.

Best Regards,

Mahendra

KPI Report.yxwz

Bren_Spill2

@Mahendra1997 - Generally, you want to have the Block Until Done tool in the workflow at the earliest point where data is splitting into multiple streams. I can see a couple of places in your workflow where you can add/move tools:

1 - In the bottom portion of the workflow, the data splits into three streams of data, writing five outputs. You have two Block Until Done tools immediately after the Sort tool, these can be combined into one as per screen shots below. The Block Until Done tool further on in that stram of data looks to be correctly placed.

2 - The T output of these filter tools is sending data to different sections of the workflow where outputs are written. You can also try placing Block Until Done tools after the T output to see if that helps

I haven't been able to test this out as the workflow dependencies are not saved as all relative. But hopefully this is helpful.

Thanks