I have a workflow with multiple inputs that generates an output with several tabs based on a join function.
For example, if there is data in either the left, right, or join, it will create a tab in the output file. However, if there is no data, a tab will not be created.
There is an issue where, when there is data flowing from both the left and right join functions, it creates a new tab.
When I go back to the input data to correct it so that all rows are joined, the output still contains the Excel tabs from the previous run (left and right). I expected to see only one tab containing all the joined rows.
Conversely, when the output contains one tab for all the joined rows and I go back and update a row in the input file incorrectly, I expect to see multiple tabs for the join function but only see one tab for the matched rows.
Is there a way to overwrite the tabs or file with each run?
I have tried setting the Output Option to Overwrite File, but it does not create the new tabs. When I select the option to Overwrite Sheet or Range, it preserves the data from the previous run.
