xlsx output for particular sheet not exported due to no data

Question

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.?

HomesickSurfer · Answer

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

ChrisTX · Answer

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-present/td-p/369481

Chris