Procedure

Double-click the tFilterRow component to show its Basic settings view.
Select the Use advanced mode check box, and type in the following expression in the text field:
```
input_row.City.equals("Chicago") || input_row.City.equals("New York")
```
This defines two conditions on the City column of the input data to filter records that contain the cities of Chicago and New York, and uses a logical OR to combine the two conditions so that records satisfying either condition will be accepted.
Press Ctrl+S to save the Job and press F6 to execute it.

As shown above, the result list of the previous scenario has been further filtered, and only the records containing the cities of New York and Chicago are accepted.

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 – please let us know!