Tool that can alert me after the workflow is run

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??

Bug

Accepted answers

IraWatt

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:

Example0206.yxmd

All comments

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!

Error if days missing.yxmd

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!

missing dates.xlsx

IraWatt

Hey @yeojy,

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

Any questions or issues please ask
HTH!
Ira

Example0206.yxmd

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

Example0206.yxmd

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 any time !

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703