When you create a rule in advanced mode, you must follow the specific syntax of the Data Shaping Expression Language .
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... *
|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... *
|isOnDayOfWeek(myVar, "Tuesday") isOnDayOfWeek(myVar, 2)|
|* This applies for the rule definition and the dataset. For example:
These functions are also available in basic mode. For more information, see the list and examples.
Important: For security reasons, a few regular expressions cannot be used, especially the backreferences. For more information, see the RE2/J documentation.