Feeding New Tab into Existing Excel Sheet

Question

I have a workflow that I've used to feed the output data into an existing excel file for over a year.  today I ran the workflow and the new tab would not load into the existing excel file.  I should note that the new tab had no data except headers -- the results of the workflow came back "negative" for the data I was searching for.  I've had many instances in the past year of the data coming up empty (headers only, no data) and the tab loads into the existing excel sheet, so I don't understand why it's not working now.  I"ve tested the functionality by creating a new output that contains data (headers + many rows) just to see if that's an issue, and it did work.  So why am I not able to load in a tab with headers only now?  this has been succesful in the past.  Very confusing, so if anyone has any idea's I'd love to hear them.  Thanks!

Rob48 · Answer

I would not doubt that this would work (i have not tried it) but what I'd really like to understand is why it stopped working in the first place.  Does anyone have experience with feeding a blank (headers only) tab into an existing excel sheet, and if so can you share the last steps in the workflow?  I'm racking my brain why it would stop working for no apparent reason.

MattBSlalom · Answer

Here's a sample that results in the empty sheet since the "real" data doesn't match my last filter.  The first path writes the dummy data record to create the sheet/file, then the 2nd flow overwrites the now existing sheet with the empty dataset.

create Excel sheet with dummy data.yxmd

Rob48 · Answer

Your statement about my desired result is correct.

Do you mean create a dummy tab in the existing excel sheet?  if so, I tried that and still no luck.