Alteryx Designer Desktop Discussions

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

Automated Workflow for Scheduled Email Notifications with Status Tracking

KamenRider
11 - Bolide

Hi,

 

I am developing a workflow that is scheduled to run at specific times. The workflow checks if a file has been updated with today's date, matching the "DateWrite" field. If a match is found, the workflow sends a notification email. The input file contains a status field that changes from 0 to 1, where 1 indicates that the email has been successfully sent. Although the workflow is scheduled to run twice a day, it will not send an email if it detects a status of 1, as this indicates that a notification has already been sent.

 

no issue.PNG

 

The issue I'm encountering is that when no records are displayed, the status field becomes blank instead of showing 0 or 1.

 

results no displayed.PNG

 

zero displayed.PNG

 

I hope someone would help me solve this problem.

 

Thanks

Kamen

1 REPLY 1
KamenRider
11 - Bolide

Hi guys,

 

any help from somone?

 

Kamen

Labels
Top Solution Authors