Filter expressions - Cloud - 8.0

tMap

Version
Cloud
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 Studio
Content
Data Governance > Third-party systems > Processing components (Integration) > tMap
Data Quality and Preparation > Third-party systems > Processing components (Integration) > tMap
Design and Development > Third-party systems > Processing components (Integration) > tMap
Last publication date
2024-02-20

In the tMap component, you can click the filter button and write a filter expression to filter the output data, as shown below:

If there are multiple conditions, you need to use the logical operators (AND, OR) to combine multiple conditions. For example:

AND operator: all conditions should be satisfied.

row1.postal_code!=null&&row1.gender.equals("F")

In this example, the postal_code column should not be null AND the gender should be F.

OR operator: one condition should be satisfied.

row1.country.equals("CN")||row1.country.equals("FR")||row1.country.equals("US")

In this example, the country column should be one of CN, FR or US.