← All features

Canvas nodes

Column Filter

Keep or remove rows based on a pattern in one column.

How it works

Choose a single column, enter a text pattern, and decide whether to keep or remove matching rows. Use a wildcard or regular expression for variable values.

Click Column Filter on Canvas, then change Pattern in the inspector. Only the three Shipped orders remain.

Simple example

Connect an orders table, select Status as the column, and set the pattern to Shipped with Rows set to Keep. Only rows whose Status cell matches Shipped continue.

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

3 rows
Order IDRegionAmountStatusCustomer IDReference
A101West140ShippedC1Retail
A103West220ShippedC3Retail
A105East126ShippedC2Outlet

Complex workflow

A warehouse includes test orders whose Order ID starts with TEST-. Select Order ID, enter TEST-* as the pattern, and choose Remove. Notes and other columns can mention tests without causing a genuine order to be dropped.

Column 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

4 rows
Order IDReferenceStatusAmount
A101RetailShipped140
A103DEMO-FEEDShipped220
A104Test noteCancelled38
A105OutletShipped126