Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

is there any way to get output file as a mail if we have nothing to report?

Anjankumar2021
8 - Asteroid

Hi All,

 

after running a workflow successfully, I did not receive output file as we have nothing to report(no data in output file).

 

1. any way to get output report (blank report) with headers

or

2. can we send that blank report as automatic mail from Alteryx?

 

 

kindly advise.

4 REPLIES 4
ShankerV
17 - Castor

Hi @Anjankumar2021 

 

I would suggest to create a column name with 0 below using the Count Records Tool.

This will resolve your issue.

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @Anjankumar2021 

 

Below is the solution which will help to trigger even the report is empty.

ShankerV_0-1670953561427.png

 

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @Anjankumar2021 

 

The Append fields tool also has the Select tool functionality where you can rename the column name.

also you can move anywhere in the order.

 

ShankerV_0-1670953804503.png

 

ShankerV_0-1670954011271.png

 

ShankerV_1-1670954023283.png

 

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

 

Many thanks

Shanker V

 

PanPP
Alteryx Alumni (Retired)

Hi @Anjankumar2021 

 

You should be able to send a blank report with headers.

 

Can you provide the WF you used so I can see if the tools are configured properly?

 

Does the email tool have a report that is attached?

 

Hope this helps.

Labels
Top Solution Authors