You might need to parameterize the filter condition when the Filter transformation is in a dynamic mapping. The filter condition might change based on the generated ports in the transformation at run time.

To use an expression parameter for the filter condition, choose

Specify by Parameter

on the

Filter

tab of the Filter transformation properties.

The following image shows the

Filter

tab when you specify the filter condition with a parameter:

You can browse for and select an expression parameter that you already created. Or, you can create an expression parameter.

To create an expression parameter, click

New

. Enter a name for the parameter, a description, and the default expression value.

The following image shows where you enter the parameter:

You can enter a default expression on the Parameters dialog box. If you want to use an Expression editor, click Edit. When you use the Expression editor, you can select functions and ports to use in the expression. You can validate the expression.

The following image shows the Filter tab with a parameter for the filter condition:

The expression parameter is a mapping parameter. You can override the parameter in a parameter set or a parameter file at run time.