The expression language used in advanced mode
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, 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.