To configure a filter condition, select a source field and configure the operator and value to use in the filter. You can select a field from either source. Fields from the original source are prefixed with the characters

SRC_

or

IN_SRC_

.

When you define more than one filter condition, the task evaluates them in the order that you specify. The task evaluates the filter conditions using the AND logical operator to join the conditions. It returns rows that match all the filter conditions.

Create a filter expression using the expression editor. You enter one expression that contains all filters. You can use source fields and built-in functions in the expression.

For more information about advanced filters, see Advanced data filters.