Preparation node
Filter
Split rows by a condition: matches go to True and the rest to False.
What it does
Splits the incoming rows by a condition: rows that match leave the True anchor, everything else leaves the False anchor, so together they're the whole input. Build a simple condition with the picker, or write a custom SQL expression.
Inputs and outputs
| Inputs | One. |
| Outputs | True, False. |
When to use it
- Keep only the rows you want (wire up just True)
- Route rows two ways at once (True and False)
- Express complex logic with AND / OR
Examples
Basic comparison
[status] = 'active'
Basic mode: column, operator, value.
Numeric range
[age] BETWEEN 18 AND 65
Custom mode.
Combine conditions
[amount] > 100 AND [country] = 'US'
Text match
[email] LIKE '%@gmail.com'
Or use the basic “Contains” operator.
Date comparison
[FL_DATE] < '2022-01-01'
Dates are always YYYY-MM-DD.
Tips
- A custom expression must evaluate to true / false.
- Dates are written YYYY-MM-DD (and date-times YYYY-MM-DD HH:MM:SS) everywhere in Trinium. 01-01-2022 is rejected, because a month-first date can't be told apart from a day-first one.
- In Basic mode, text comparisons ignore case by default; turn on Match case to change that.
- Both anchors are optional to wire: connect only the side you need.
- More than two destinations? Use Route instead of chaining Filters. It makes one pass and gives every branch its own named anchor.