Resolving: Unable to Open File for Write

[KamenRider]

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

[leonhekkert · Accepted solution]

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.

[KamenRider]

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

[alexnajm]

@KamenRider you are using regular Containers:  Tool Container Tool

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

[KamenRider]

Thanks guyss @leonhekkert @alexnajm 

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

Kamen