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 concat('
',FirstName,LastName) == FullName
validates that the full name
corresponds to the first name concatenated with the last name with a space as a
separator.
The following functions are specific to the data quality rules as a supplement
to the expression language:
Function | Details | Example |
---|---|---|
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.