Export .xlsx file with no records

Hello,

I would like my workflow to export an excel file with all outlined field headers even if there are no records found during the period run.

Any help? Thanks!

Reporting

Accepted answers

Hi @valeriemattas,

there shouldn't be any difference. I just tried it.

"Workflow" attached. Just try it yourself.

Best

Alex

2020-04-09 Export xlsx file with no records.yxmd

All comments

Hi @valeriemattas ,

That is possible without any configuration needed.

Take a look and let me know if you need further assistance.

Best,

Fernando Vizcaino

2020-04-09 Export .xlsx file with no records.yxmd

Hi @valeriemattas,

there shouldn't be any difference. I just tried it.

"Workflow" attached. Just try it yourself.

Best

Alex

2020-04-09 Export xlsx file with no records.yxmd

Do a count records and union to the dataset. This way there will always be at least 1 row of data to write to the file

Thanks @grossal - not sure why it wasn't working previously... Appreciate your time.

Thanks @fmvizcaino - not sure why it wasn't working previously... Appreciate your time.

Quick Links

Unanswered
Community Events
Groups

Tags

This months top contributors

atcodedog05 19598

Qiu 15875

MarqueeCrew 13708

apathetichell 13703