As the data quality rules are validation rules, use the expression language to validate the data, not to transform them.
For example: The expression
',FirstName,LastName) == FullName validates that the full name
corresponds to the first name concatenated with the last name with a space as a
The following functions are specific to the data quality rules as a supplement to the expression language:
|isInMonth(myVar, myMonth)||Type a month or a number from 1 to 12.
1 = January (…) 12 = December *The supported languages are: English, French, German, Portuguese, and Spanish. *
You can also use the English abbreviations: Jan, Feb, etc. *
|isInMonth(myVar, "July") isInMonth(myVar, 7)|
|isInYear(myVar, myYear)||-||isInYear(myVar, 2020)|
|isOfType (myvar, myType)||Type a semantic type or standard type: boolean, date, decimal, or integer.||isOfType (myVar, "Integer")|
|isOnDayOfMonth(myVar, myDay)||Type a number from 1 to 31.||isOnDayOfMonth(myVar, 18)|
|isOnDayOfWeek(myVar, myDay)||Type a day or a number from 1 to 7.
1 = Monday (…) 7 = Sunday *The supported languages are: English, French, German, Portuguese, and Spanish. *
You can also use the English abbreviations: Mon, Tue, etc. *
|isOnDayOfWeek(myVar, "Tuesday") isOnDayOfWeek(myVar, 2)|
For entries that specify the supported languages, the information applies for the rule definition and the dataset. For example:
- You defined the rule using the value Wednesday. If the dataset contains the values Mercredi, 3 and Wed, the value Wednesday is considered to be equal to these three values.
- You defined the rule using the value Juni. If the dataset contains the value June, the value Juni is considered to be equal to June.