Transformations > Filter transformation

Filter transformation

The Filter transformation filters data out of the data flow based on a specified filter condition. To improve job performance, place the Filter transformation close to mapping sources to remove unnecessary data from the data flow.
A filter condition is an expression that returns TRUE or FALSE. When the filter condition returns TRUE for a row, the Filter transformation passes the row to the rest of the data flow. When the filter condition returns FALSE, the Filter transformation drops the row.
You can filter data based on one or more conditions. For example, to work with data within a data range, you can create conditions to remove data before and after specified dates.
Link a single transformation to the Filter transformation. You cannot merge transformations into the Filter transformation.