Ignore error while saving multiple excel files

[mohit9garg]

I am updating multiple excel files with the help of an Alteryx workflow. the whole workflow gets failed if a file is opened on any user's machine.

Is it possible that workflow ignores only that file and proceed with updating rest of the files.

PS: Output is saved from a single OUTPUT tool which mean multiple files are saved from a single large dataset.

Thanks

[cjaneczko]

You need to use a Block until done or Control Container for each Output so the workflow can save each Tab or Range without throwing the error. Alteryx wont run or output the next branch of the workflow until the current branch has completed and saved. Here is an example of one of my flows with the Block Until Done.

[cjaneczko]

This is an example of using the Control Container for each output. The output anchor on the top right of the Container wont let the next part of the flow run until that container has resolved.

[mohit9garg]

@cjaneczko Output is saved from a single OUTPUT tool which mean multiple files are saved from a single large dataset.

[cjaneczko]

What does the configuration of your output tool look like? And what does the error say?

edit: Actually after reading your update. I dont believe you can get around this without everyone being out of the files. 

[mohit9garg]

@cjaneczko I was using below macro-

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Allowing-workflow-to-ignore-qu...

After recent upgrade it start throwing below error message-

Error: output macro (91): Record #11: Tool #4: Internal Error - Deadlock detected (@1)