Output more than 1 data set to the same excel file?

Question

Currently, I have a filter applied to my data set, I'd like the 'true' population to export to a specific file on a specific tab. For the 'false' population, I'd like to export to the same file but on a separate tab. I set up the excel file with the 2 separate tabs and created the connections to each tab. The 'true' population is exporting to the tab specified, however, the 'false' population wont export - the error I am receiving is  "The process cannot access the file because it is being used by another process"

Is this a configuration issue? or am I unable to export multiple datasets to the same file?

Any advice is welcome - thank you in advance.

sergejs_kutkovics · Answer

@CDIns , there are basically two ways to achieve this. One way to use Formula tool and Output tool configuration as mentioned @binu_acs. Or use Control Containers, but you need Alteryx version 2023.1 or newer.

Output more than 1 data set to the same excel file.yxmd

TheMattLeonard · Answer

This is a fundamental issue with Alteryx I'm honestly surprised hasn't been addressed more robustly. Essentially what is happening is that "the other process" generating your error is Alteryx itself writing to the other tab. There is a tool you can use to avoid this issue called "Block until Done". Unfortunately since you're trying to implement this at a filter, you'll need to duplicate the filter, so you have one filter coming off of the 1 output and 2 output of the Block Until Done tool, and then each filter will have one output. One where it's only coming from True and the other where it's only coming from False.

Hope this helps!

binu_acs · Answer

@CDIns one way of doing this

Same_Excel_280224.yxmd