Filter Rows

Description

Filter Rows evaluates each incoming row against one or more conditions and routes it to either a true or false output hop based on the result. Use this step whenever your workflow needs to split data into separate paths — for example, sending valid records to a database output and invalid records to an error log. Conditions can compare fields to static values, other fields, or use operators like IN LIST for matching against multiple values. You can also build nested sub-conditions with AND, OR, and NOT logic for complex filtering scenarios.

Configurations

Field Name	Description
Step Name	Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
Send ‘true’ data to step	Choose a step to send the rows for which the condition specified is true.
Send ‘false’ data to step	Choose a step to send the rows for which the condition specified is false.
The Condition	Click <Field> to select from a list of fields from the input stream(s) to build your condition(s). <value> to enter a specific value into your condition(s). To enter an IN LIST operator, use a string value separated by semicolons. This also works on numeric values like integers. The list of values must be entered with a string type, e.g.: 2;3;7;8 To delete a condition right-click and select Delete Condition.
Add Condition	Click ‘Add condition’ to add conditions. Add condition converts the original conditions into a sub-level conditions. Click a sub- condition to edit it by going down one level in the condition tree.