Multiple Outputs

I'm trying to write to multiple outputs. In total, there will be 13 output files with 3 tabs each and 1 output file with 42 tabs. I've tried putting Block Until Dones in basically every possible position within the flow but that doesn't seem to solve it. Does anyone have any tips on how to write to this many output files without getting the "Unable to open file for write" error?

Capture.PNG

Capture2.PNG

Output

Accepted answers

DataNath

@carterfleming for the single file to multiple sheets, are you just splitting the dataset on a certain field to get the sheets you want? If so, I built a macro which will do this for you. You can find that here (the configuration is fairly straight forward but happy to help if there's any issues): https://community.alteryx.com/t5/Public-Community-Gallery/Output-to-multiple-Excel-files-or-sheets/ta-p/951995

For the 13 files of 3 tabs each, how are you currently breaking these down? I.e. do you split on field X to get your files, and then split on column Y to further break that down into the sheets within? @fvilelabr wrote a brilliant post on how to do this with a batch macro: https://community.alteryx.com/t5/Engine-Works/Output-multiple-excel-files-with-multiple-sheets-based-on-2/ba-p/735077

However, if you're keen to stick with your original flow, I think the issue is just the placement of your Block Until Done tools. You're currently staggering the final step (i.e. the 1 and 2 in A/B). However, you need Block Until Done tools a step before in order to ensure that Alteryx doesn't run A + B parallel, which will cause issues as B is currently trying to write to a file already being written to by A: