3 excel outputs in one single excel file

[harithad1]

Hi. I created a workflow which has 3 outputs (different excels with no common fields). Is there a way to have all the outputs in one excel file in different tabs?

[Qiu]

@harithad1 
Check the reply of mine. it should fit your question.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Issue-with-Alteryx-Workflow-Mu...

[grazitti_sapna]

You need to close all files that are linked to the output file, whether it's the same Excel file or if this Excel file is being used as a source for another file.
you can refer to attached WF

Thanks!

[cjaneczko · Accepted solution]

The BUD's are not in the correct spot which is leading to the error. The BUD goes where the branches split. Its still processing your entire workflow as one flow and not pausing at each branch. You'd need to put it before the filter and use two filters. Then put one more BUD on the false side of the filter as you have a split there as well. If you have Control Containers in the version you are working with, it is probably easier to use those. 

Ignore the errors in my flow as there is no data in it. But this shows you the mapping to fix your workflow.

[harithad1]

This worked. Thank you very much :)