Date issue

[venkatac7998]

Hi

 I have an altreyx workflow that receives data from 2 different tables. for some reason, one of the tables has not been uploaded with data for 2 weeks, so how will I be alerted for an issue like this in the future? because workflow runs with no issues. I tried using an email tool and a Count tool, but the issue is whenever workflow runs, the count tool counts the records, which there will be old records. I need to count records every day and should receive an email if there are no new records for that day. any help is appreciated

[ed_hayter]

You could make a validation workflow where you join on to previous day data. Then if there are no records in the new data output anchor you can flow to message saying no new information.

I have attached a workflow that looks at logic. The bottom one is the scenario of no new records (based solely on one field - this can be changed by re configuring the join)