email the attachment only when the attachement has data in it

[harsha_rappan]

Hello,

1. I create workflows and the output is stored in excel spreadsheet, I attach the spreadsheet to an email and send the email to the user.

2. I schedule the workflows in Alteryx gallery to run once a week, lets say on every Monday.

3. Not every Monday will the output have data in the spreadsheet.

4. The output or the spreadsheet will have data only on certain Mondays, not every Monday of the year.

5. I will schedule the workflow to run every Monday and the workflow should run successfully.

6. My requirement: I want the emails to be generated only when the spreadsheet or the attachment has data generated, if there is no data, DO NOT GENERATE THE EMAIL

7. I don't want to send emails unnecessarily to the users every Monday.

Any help is truly appreciated.

Regards,

Harsha Rappan

[Maskell_Rascal]

CReW Macros has a Blocking Test macro that should help with your problem. You would first use the Count Records tool to determine if there is any data coming in from your data source, and then feed that into your Blocking Test tool to stop the workflow from running if no data exists. I've attached a simple example that outputs to an excel file if there is any data available for output. You would want to connect this before either your Email tool or your file output. 

[harsha_rappan]

Thank you for the sharing the workflow, unfortunately my alteryx version is an older version, the blocking test macro is not supported, we are having issues with upgrading to newer versions.

Any other solution with basic tools available in the older version? Any help is highly appreciated.

Regards,

Harsha Rappan 

[Maskell_Rascal]

Hi @harsha_rappan 

Sorry to hear that the Blocking Test macro didn't work for you. It's basically a user friendly version of the Message tool on the Developer tab. Attached is another workflow that recreates what the Blocking Test macro does, only this should use all existing tools that are available to you. 

Please let me know if this new version works for you.

Thanks!

Phil

[Magneto_]

This helped immensely! Thank you!!!