← All features

Canvas nodes

Filter

Keep or remove rows when a cell matches a pattern.

How it works

Enter a pattern to match across the row's cells and choose whether to keep or remove rows with a match. Use the Column Filter node when the pattern belongs to a specific field.

Click Filter on Canvas to open its settings and output. Only the matching Cancelled order remains.

Simple example

Enter Cancelled as the pattern and choose Keep. Filter returns rows with a cell that matches Cancelled anywhere in the table, which helps when the marker can appear in more than one column.

Filter selected in n0is Canvas in the simple example.
n0is Canvas · Sample dataView full size

Input

First 5 of 6 rows
Order IDRegionAmountStatusCustomer IDReference
A101West140ShippedC1Retail
A102East85PendingC2Outlet
A103West220ShippedC3Retail
A104North38CancelledC9Retail
A105East126ShippedC2Outlet

Node output

1 row
Order IDRegionAmountStatusCustomer IDReference
A104North38CancelledC9Retail

Complex workflow

A combined export puts test identifiers in either Order ID or Reference. Enable Regex, enter ^(TEST|DEMO)-, and choose Remove. A matching prefix in any cell excludes that row, so use Column Filter instead if the check should apply to just one field.

Filter selected in n0is Canvas in the complex workflow.
n0is Canvas · Sample dataView full size

Input

5 rows
Order IDReferenceStatusAmount
A101RetailShipped140
TEST-A102QAPending85
A103DEMO-FEEDShipped220
A104Test noteCancelled38
A105OutletShipped126

Node output

3 rows
Order IDReferenceStatusAmount
A101RetailShipped140
A104Test noteCancelled38
A105OutletShipped126

Workflow result

1 row
sum_Amountcount_rows
3043