output .xlsx file not being created if their is 0 records

[wonka1234]

My output has 0 records. I believe it isnt being outputted because I output with a formula field.

I outputted to a manually created field called output:

How can I still output to this path if 0 records are being passed.

Is it possible to still output the .xlsx file? I still would like the file empty or not to be outputted.

[Tanai_Goncalves]

Hello @wonka1234 

Not really sure what you want to achieve.

0 records means no data. But Alteryx will output the columns names without data.

Does appear any error message?

a sample of the workflow would be great.

Regards,

Tanai

[jbichachi003]

Hi @wonka1234,

I'm assuming you're trying to output your result using the Output Data tool instead of the Render tool (I'm assuming this because you used the notation ".xlsx|||Data" to create the output, which is a notation specifically reserved for the Output Data tool).

I've attached a potential solution (created in Alteryx Designer, version 2020.4).

This solution ensure that an output always prints, regardless of whether there are zero records or more than zero records.

Note, in the event that there are zero records, this solution will print "NO RESULTS FOR THIS CELL" in each blank column, regardless of the data type. If you do not want this feature, you can delete the Multi-Field Formula tool.