email the attachment only when the attachement has data in it

Question

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

Magneto_ · Answer

This helped immensely! Thank you!!!

Maskell_Rascal · Answer

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

stop data ouput if no records exist.yxzp

harsha_rappan · Answer

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