Filter
Filter Rows
Tests each row against conditions on one or more columns, linked with AND / OR, and sends matching rows out the True output and the rest out the False output.
When to use it
Use it to narrow a dataset to the rows that matter, or to split one stream into two so each half can be handled differently.
In a pipeline
File InputFilter RowsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Match Logic | select | Yes | AND |
| Conditions (JSON) | textarea | — | [{"column":"Status","operator":"eq","value":"Active","join":"AND"}] |
| Custom Grouping | text | — | e.g. (1 OR 2) AND 3 — leave empty to use the AND / OR links |
Example
Closed orders over 100, or any order from VIP customers
- Conditions=1 Status equals Closed AND 2 Amount greater than 100 OR 3 Tier equals VIP
| Order | Status | Amount | Tier |
|---|---|---|---|
| A-1 | Closed | 120 | Standard |
| A-2 | Open | 80 | VIP |
| A-3 | Closed | 45 | Standard |
| Order | Status | Amount | Tier |
|---|---|---|---|
| A-1 | Closed | 120 | Standard |
| A-2 | Open | 80 | VIP |
The links read as (1 AND 2) OR 3. A-3 is not discarded; it leaves through the False output.
Worth knowing
- This node has two outputs. Connect the False output when the rejected rows still matter.
- Each link between two conditions is its own AND or OR, and AND is applied before OR, as in SQL: 1 AND 2 AND 3 OR 4 OR 5 means (1 AND 2 AND 3) OR 4 OR 5.
- For any other grouping, type a Custom Grouping over the condition numbers, such as (1 OR 2) AND NOT 3. It overrides the links.
- Compare with Column checks one column against another in the same row, such as Shipped Date greater than Due Date.
- Greater and less than compare numbers when both sides are numbers, and text otherwise; the other operators compare text exactly, including case.
- Is Empty and Is Not Empty ignore the value and count a whitespace-only cell as empty.