Filter expressions

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.