In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Export .xlsx file with no records

valeriemattas
8 - Asteroid

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!

 

5 REPLIES 5
fmvizcaino
17 - Castor
17 - Castor

Hi @valeriemattas ,

 

That is possible without any configuration needed.

 

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

Best,

Fernando Vizcaino

grossal
15 - Aurora
15 - Aurora

Hi @valeriemattas,

 

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

 

grossal_0-1586466964873.png

grossal_1-1586466983283.png

grossal_2-1586466992221.png

 

 

"Workflow" attached. Just try it yourself.

 

Best

Alex

DavidP
17 - Castor
17 - Castor

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

 

DavidP_0-1586467177275.png

 

valeriemattas
8 - Asteroid

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

valeriemattas
8 - Asteroid

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

Labels
Top Solution Authors