This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
As per my knowledge, when the datasets are coming out of different workflows or branching out from the same workflow then you need to add a block until done before the output tool of each these branches or workflows so that alteryx writes the output to the common file one at a time and not all at the same time.
Remember to keep different sheet name though for all your output tabs.
See below pic for reference. I'm writing multiple output data to the same file within different tabs using the block until done.
P.S: If this solves your query, kindly mark this as solution
Start: Designer x64: Started running O:\_Official Workflows\TEST NGU .yxmd at 05/18/2020 10:34:57 Error: Output Data (31): Unable to open file for write: [Redacted path]\Cancel & Amend Report NGU Template.xlsx Error Opening file: [Redacted path]\\Cancel & Amend Report NGU Template.xlsx : The process cannot access the file because it is being used by another process. (32) End: Designer x64: Finished running TEST NGU .yxmd in 6.9 seconds with 1 error and 1 warning
You can also look at using the reporting functionality, create individual tables and add a layout (horizontal), then merge them using a Join multiple. Then split out the tabs using the Vertical with split layout tool to get your output on multiple tabs.
I'm unable to pinpoint the exact reason for the error in your workflow. However, I get such issues, when I run a workflow where the input file is open in excel. Basically, when I'm done reviewing an input file and run the workflow without closing that input file, I get such errors.
By any chance, has the output file been opened or accessed, before the final leg of the workflow could be completed?