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.
@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
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |