How To Output Multiple Excel Sheets from the Join Tool

[NBlancorodriguez]

Hello

I'm trying to output multiple sheet to Excel from the results of the Join Tool. I need the Joint Results in one Sheet, the Left Results in another and Right Results in another Sheet. I have tried the Block Until Done but I keep receiving the error message "The Process cannot access the file because it is being used by another process (32).

[Robin_McIntosh]

Do you have the file open while the workflow is running?  Alteryx cannot write to a file if it is opened by you or someone else.

[Robin_McIntosh · Accepted solution]

Actually, your Block Until Done is not correct.  Try this example instead if you are wanting to output all R/J/L results into one workbook on separate sheets.