Filter

Keep only the rows that match one or more conditions.

When to use this

• You want to drop rows that do not belong in the downstream analysis (wrong region, inactive products, test data)
• You want to split a file into segments by condition (for example, one branch for retail customers, another for wholesale)

What you need

• One upstream data source wired into the Filter node
• The column names you want to filter on (case-sensitive, as they appear in the upstream data)

Parameters

Set conditions in the side panel. Each row in the Conditions list is column · operator · value. The toggle at the top combines them:

Setting	Options	Description
Combinator	AND, OR	AND keeps rows that match every condition. OR keeps rows that match any condition.
Operator	=, !=, >, <, >=, <=, contains, not contains	How the column value is compared to the condition's value.

= and != compare as strings. >, <, >=, <= convert both sides to numbers, and a non-numeric value fails the check. contains and not contains test whether the condition's value appears anywhere in the column value.

If no conditions are configured, every row passes through.

What you get

The same columns as the input, with only the rows that pass the conditions.

Workflow wiring

flowchart LR
    n1["Import Data (orders.csv)"] --> n2["Filter (status = #quot;active#quot;)"]
    n2 --> n3["Aggregate"]
    n3 --> n4["Create Scenario"]

Common mistakes

• Comparing numbers with >, <, >= or <= on a column that has non-numeric values. Those rows fail the check
• Mismatched column names. Names are case-sensitive and must match the upstream data exactly
• Expecting OR behaviour when the toggle is set to AND (or vice versa). Toggle the AND / OR button at the top of the conditions list