Tool that can alert me after the workflow is run

[yeojy]

hihi, i have input from various files, the workflow will help me to filter, sort generate rows etc. and at the end of the day i want a last check or alert to let me know if the output has every single date of the month instead of me manually going into the output to see if there are any missing dates of the month

any tool in alteryx that can help me to check or alert me??

[IraWatt]

Hey @yeojy,

What I think you want is the message tool, you can apply logic then it will send a message to the results window:

Or you could use an email tool if you wanted to go that way.

Any questions or issues please ask :)
HTH!
Ira

[DataNath]

Have mocked up something quickly similar to your example!

[yeojy]

hi @DataNath @IraWatt both really helpful, thank you! what if tdy i already have a full list of dates and want a message to appear saying that there are missing dates in the month? like the file attached, i have 1may missing from this file, so how can i use message to alert me that there is a missing date in this file? thanks in advance!

[IraWatt]

Hey @yeojy,

Here is an example of how to do that with your dataset:

Any questions or issues please ask :)
HTH!
Ira

[yeojy]

hi @IraWatt this is amazing, though when i tried to add in 1May into the excel sheet that i provided earlier, i noticed the below, seems to work fine if i remove the 2nd set of dates though, any idea why that is happening?

[IraWatt · Accepted solution]

Ah sorry @yeojy, I miss read the question. This new workflow counts how many days there should be in each month and compares that to how many days there are in the data set. If they are not the same then the warning will appear: 

[yeojy]

@IraWatt this is amazing, tried on one of my workflow and its working well! will try on other workflow hopefully all is good too, Thank you so much for your help!

[IraWatt]

No worries @yeojy :D any time !