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.
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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!