Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Send out email only if there is data

discoverable1
6 - Meteoroid

I have a flow, that runs weekly, that runs a tabcmd script to generate two excel reports onto our network drive. There would then be one email sent out with the two attached excel reports. However, there can be cases where one or both are empty excel files since there could be no records in the tableau table the tabcmd exports the report from. How do I make sure that 1) email is only sent out when there is data in at least one of the two files 2) email is sent out with only the excel reports that do contain data? I know how I can do this process if I was only generating one excel report but two reports require another check.

1 REPLY 1
RishiK
Alteryx
Alteryx

@discoverable1 There are a couple of areas you can explore here:

 

1. Have a look at the Block Until Done to support you here, to check whether data is flowing for one or both Excel files. 
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Block-Until-Done/ta-p/...

2. The Count Records is really useful to check whether a flow will have data through the output or not, this will help you here in your check:
https://help.alteryx.com/current/designer/count-records-tool

Labels
Top Solution Authors