Email tool not sending

Question

Hi, I have a workflow that has two files (File A and File B)  that are filtered, joined together, put through layout, then sent as an email. The problem I have though is sometimes File A goes through the filters and 0 records come out (this is normal because of the stipulations I have). When this happens, File B cannot join with File A, 0 records are passed through to the layout tool from the join tool, and then no email is able to be sent out. I want to figure out if I can insert something like "No Trades Today" in place of File A when there's a case of 0 records. I'm thinking a conditional expression. If not that, is there a way I have File B just continue normally through the workflow and go through layout, then the email tool? I'll take whatever solution is easiest.

Thanks and I hope this wasn't too convoluted.

Best,

Derm

oneillp111 · Answer

Here is what I would do for each input

The count will determine if we use the actual data file or the dummy file with contains 1 row of data saying no data to output.  Feed the output from the formula to the dynamic input tool, then join both data sets and check to see if you find any cells that say no data

derm · Answer

How would I use the dummy file? I know I need to use the formula tool but I'm not sure how to do it where it uses the formula tool when empty and the original files when records are present.

oneillp111 · Answer

@derm , I would use the logic on both input files and have them determine record count, if no records then use a dummy template so the join completes, then from there determine the kind of email to send, either a "No Records today" or attached at todays records, something like that