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 under the hood

SELECT * FROM data WHERE revenue > 1000 AND status = 'active'

Try this operation →

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