The expression language used in advanced mode - 8.0

Talend Data Stewardship User Guide

Version
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend Data Stewardship
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Data Stewardship
Content
Administration and Monitoring > Managing users
Data Governance > Assigning tasks
Data Governance > Managing campaigns
Data Governance > Managing data models
Data Quality and Preparation > Handling tasks
Data Quality and Preparation > Managing semantic types
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:
  • 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.

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.