In this article, we'll be going over how to create customized data error messages when validating data in a DQ+ Analysis. Most Data Quality nodes create a boolean output on a check for a data's quality (if data is unique, if it's consistent, etc...). However, sometimes you want more unique messages so that business users can better understand the data. You can use column functions or the Javascript node to do this.
Column Functions
With a column function, you can use an IF statement that basically checks for a 'True/False' on the output of your Data Quality Check and then include an error message of your choice:
Javascript
In Javascript, you'd need to create a new field in the "Outputs" tab, then assign the custom error message to that output on a 'True/False' check like we did with Column Functions:
You can then move these fields through your analysis to perform checks against and send to Output Data Stores.
Comments
0 comments
Please sign in to leave a comment.