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.