Resolving: Unable to Open File for Write

HI,

I am executing a workflow that involves a single Excel file with two sheet tabs. However, I'm encountering an error stating "Unable to open file for write," which I suspect is due to a conflict between the two. Could you provide any examples or methods to resolve this issue without using the "Block Until Done" tool? This tool is flagged as an error on the server, so I need to avoid using it. Additionally, using a macro is not recommended

Hope someone to assist and teach me.

Thanks,

Kamen

Workflow

Reporting

Transformation

Accepted answers

Hi @KamenRider. If you are on one of the newer versions of alteryx designed you could look into control containers.

Put both output tools in a control container and link the control containers.

Normally that should fix the error.

All comments

Hi @KamenRider. If you are on one of the newer versions of alteryx designed you could look into control containers.

Put both output tools in a control container and link the control containers.

Normally that should fix the error.

Hi @leonhekkert ,

Isn't both of my output tools already in the control container? Can you show me how to link both containers?

Looking forward for your response.

Kamen

@KamenRider you are using regular Containers: Tool Container Tool

I agree with @leonhekkert - Control Containers would work well: Control Container Tool

Thanks guyss @leonhekkert @alexnajm

I never thought there is a control container that can do this. Thanks for the information.

Kamen

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703