Custom email notifications to include failing validation rules
Hi,
I am wanting to set up email notification that fire when a data quality workflow validation step returns failures. I have been able to set up the email notification itself but i want to include the actual rule and number of fails in the body of the email so it gives some context as to where to investigate.
a simple table with teh rule/group name and the failed rows would be great.
E.g
Subject:
Validation rule failure notification.
Body:
Hi,
the following rules have failed validation today:
Rule_Name | Fails |
|---|---|
Customer name must be populated | 22 |
Customer title must be populated | 10 |
Please go to (insert ADS link) to investigate further.
Thanks,
The DQ Team
Thanks in advance! 😊Answers
-
Hello, this is possible, but does take bit of effort so that it is presented nicely in the email:
Use Concatenate steps to append html tags around the information you want to include. Then pass this table as a Custom event parameter that can be used in the email body
Suggest you try this (presented poorly without the table) as a first step.
Can add more info on anything you are stuck on.0
