Why is my workflow only outputting one of the expected three tabs

[davidlocke]

I have had this happen in another workflow and it seemed to randomly fix itself.  So I'm not sure if this is a workflow issue or a glitch.

I have 2 files that I joined and used the:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/To-write-the-Left-and-Right-join-into-...

to create a tab that puts the left join, central join in a tab, and the right join in a tab in the same file.  This worked 3 times, but I was still fine tuning how I wanted to the tabs to be named.  Now It is only printing the Right Join even though Alteryx said it wrote all three tabs.

I've attached the screen shots of what Alteryx said it created and the actual tabs.

The data is sensitive, or I would share my workflow.

[ggruccio · Accepted solution]

Hi @davidlocke,

Make sure you have your Output Tool configured to Overwrite Sheet and not to Overwrite File.

Otherwise it will write the two sheets then overwrite the file when it outputs the third sheet.

[davidlocke]

Wow.  Can't believe I missed that.  Not sure how I changed it, but that was it.