Transform

Filter

Keeps only the rows that meet a condition and drops the rest. Type a condition like Amount > 50000 or Region = EMEA: one column, one operator, one value. Operators: =, !=, >, <, >=, <=, contains, startswith, endswith. Each Filter node takes a single condition; to apply two criteria, chain two Filter nodes.

Inputs

Input	Accepts	Required
Table	Table	Yes
Condition	Text	Yes

Outputs

Output	Produces
Result	Table

Example

Your Transactions table has 12,000 rows across four regions. To review only the large deals, set the condition to Amount > 50000. To then narrow to one region, connect a second Filter with Region = EMEA. The filtered result appears as its own tab, ready to sort, chart, or keep refining.

Tips

• Text comparisons ignore case: Region = emea matches EMEA.
• contains is useful for messy descriptions: Memo contains refund.
• Leave the condition blank and every row passes through unchanged.

Related nodes

• Sort
• TopN
• Deduplicate
• SelectColumns
• GroupBy