The operators - 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 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
Last publication date
2024-02-22

The following table lists the operators available in basic mode.

Operator Example Details
Type Name
Text is CustomerName is Smith -
is not FirstName is not John -
contains StatusCode contains 0AZ -
does not contain ItemID does not contain X32 -
starts with BankNumber starts with FR -
does not start with ItemID does not start with DE123 -
ends with BankNumber ends with 0089 -
does not end with BankNumber does not end with Y9 -
matches regex PostalCode matches regex ^[0-9]{5}(-[0-9]{4})?$ -
does not match regex SSN does not match regex ^\\d{3}-\\d{2}-\\d{4}$ -
is of type Location is of type Asia Select a semantic type or standard type: boolean, date, decimal or integer.
is empty DriverLicense is empty -
Number is equal to Age is equal to 21 -
is not equal to CustomerID is not equal to 16742 -
is greater than Age is greater than 17 -
is greater than or equal to Age is greater than or equal to 21 -
is less than Age is less than 16 -
is less than or equal to Age is less than or equal to 20 -
Date and time is equal to DateOfReceipt is equal to 2020-05-14 09:55:00 You can select a date or a time, or both.
The supported formats are:
  • yyyy-mm-dd,
  • hh:mm:ss,
  • yyyy-mm-dd hh:mm:ss.
is not equal to ValidationDate is not equal to 2020-09-02
is before BirthDate is before 2003-12-16
is before or equal to ExpiryDate is before or equal to 2002-01-01
is after BirthDate is after 1983-12-31
is after or equal to BirthDate is after or equal to 1971-01-01
is in (month) HireDate is in month March

-

is on (day of the week) PublicationDate is on day of the week Friday

-

is on (day of the month) PublicationDate is on day of the month 16 -
Boolean is true Validity is true -
is false Validity is false -
is equal to Access is equal to Validity These operators allow you to compare two variables of boolean type.
is not equal to Access is not equal to Validity