xlsx output for particular sheet not exported due to no data

[adarshr28]

My workflow currently has 5 output sheets.

If one of those sheets has no records, my workflow will not output a blank sheet.

Is this possible to build into my workflow? My client would still like to have a blank sheet with the column names written to the excel file, even if there is no data

Or do we have any tools which helps in counting the rows and re writing to the old sheet if needed.?

[ChrisTX]

The Count tool will always generate one record. 

Check out this post: 

Generate blank row when no data is present

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Generate-blank-row-when-no-data-is-pre...

Chris

[HomesickSurfer]

Hi @adarshr28 

Here's my approach that can also offer additional benefit...union a timestamp to the bottom of your dataset for each sheet.

If no data output, the timestamp will still be