Example. Expression Parameters in a Filter Condition
Example. Expression Parameters in a Filter Condition
Use expression parameters to parameterize the filter condition in a Filter transformation.
For example, you might use an expression parameter for a filter condition with the following default value:
EmployeeID > 100
The following image shows where you can configure the expression parameter:
If the Filter transformation is reusable, you can bind the transformation parameter to a mapping parameter. You can assign a different default value to the mapping parameter and use the mapping parameter in non-reusable transformations in the mapping.
For example, you can edit the mapping parameter and configure the following default value:
Dept < 2000
The following image shows the default value of the mapping parameter: