Headers not in the Output

Question

Hi Team,

I'm having an issue with the Output of my excel file with 4 sheets

Basically sometimes the sheets output with no data only headers.. Eg: the "Closed" sheet might just have headers and no actually data as threes was no closed agreement.

When running this workflow the Output (excel file) only brings out the sheet with and ignore/removes the other sheets like this "Closed" sheet

How do I ensure that the sheets even if they don't have data and only headers are giving an output with just the headers and won't remove the sheet entirely?

Here's my result in Alteryx - I should ideally have these 4 headers in my excel file in Sheet named Closed

Here's my config for the tools

In the final excel file the sheet is removed completely with no headers output

Please help

vizAlter · Accepted Answer

Hi @henrygeorge  — Can you attach the sample file and workflow?

Also, look at the trick that how can you show empty rows when you have just a top row for the headers only, and not a single record available.

I just put the cell borders on "Sheet-Empty" sheet. Try this if it gives you an idea.