Filter
Show only rows matching conditions
What It Does
Filter lets you keep or remove rows based on conditions. Use the condition builder to create rules like "revenue > 1000" or "status = 'active'", or write SQL WHERE expressions directly.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Filter". It's in the Filter & Sort group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Conditions | Condition builder | Yes | One or more filter conditions combined with AND/OR |
Action | Select | No | Keep matching rows (default) or Remove matching rows |
SQL Generated
SELECT * FROM data WHERE revenue > 1000 AND status = 'active'Notes
- Null values are handled gracefully - operations skip or preserve nulls where appropriate.
- You can edit any pipeline step by clicking on its card to re-open the panel with the same settings.
- The SQL preview shows exactly what will execute - inspect it before applying.
Related Operations
- Limit Rows - Keep only the first N rows
- Top / Bottom Rows - Show top or bottom N rows by column value
- Remove Duplicates - Remove duplicate rows