Apply filter conditions to filter the source data that you transfer to the target.
You can apply the following types of filter conditions:
Simple
Select the source field, and configure the operator and value to use in the filter.
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.
Advanced
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.