You can test data based on one or more group filter conditions. You can enter any expression that returns a single value. You can also specify a constant for the condition. In advanced mode, the filter condition must evaluate to a numeric result.
A group filter condition returns TRUE or FALSE for each row that passes through the transformation, depending on whether a row satisfies the specified condition. Zero (0) is the equivalent of FALSE, and any non-zero value is the equivalent of TRUE.
When the task runs, Data Integration handles the data in the following ways:
•Passes the rows of data that evaluate to TRUE to each transformation or target that is associated with each user-defined group.
The Router transformation can pass data through multiple output groups. For example, if the data meets three output group conditions, the Router transformation passes the data through three output groups.
•Passes the row to the default group if all of the conditions evaluate to FALSE.
You cannot configure a group filter condition for the default group. However, you can add an Expression transformation to perform a calculation and handle the rows in the default group.
Configuring a group filter condition
Configure a group filter condition for each user-defined output group.
1Connect the source to the Router transformation.
2Click the Output Groups tab.
3Click the + sign and add the group you want to configure.
4Click Configure.
5In the Edit Filter Condition dialog box, select one of the following filter condition types:
- Simple. Enter a simple condition based on available field names and operators.
- Advanced. Select this option to open the expression editor and validate the syntax for a complex condition.
- Completely Parameterized. Select this option to base the filter condition on an input parameter.
The following image shows the Edit Filter Condition dialog box:
6Click the + sign to add a row for each condition that you want to apply to this group.
7Choose a Field Name, Operator, and Value for each condition.
