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.