← All features

Canvas nodes

Unique Filter

Keep the first row for each key or isolate subsequent repeats.

How it works

Select the columns that identify a record, or use all fields. Keep the first row for each key or return subsequent occurrences to inspect repeats.

Click Unique Filter on Canvas, then change Keep in the inspector. The output keeps one row for each customer ID.

Simple example

Choose CustomerID as the key and keep unique rows. If a customer appears several times, the node keeps the first row for that ID.

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

Input

4 rows
CustomerIDCity
C-01Austin
C-02New York
C-01Dallas
C-03Denver

Node output

3 rows
CustomerIDCity
C-01Austin
C-02New York
C-03Denver

Complex workflow

Sort events from earliest to latest, then choose Account and Event as the key and switch to duplicates. The output isolates subsequent occurrences of each account-event pair for review.

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

Input

First 5 of 6 rows
AccountEventEventDate
A-1Login2026-10-04
A-2Login2026-10-05
A-1Reset2026-10-07
A-1Login2026-10-08
A-2Login2026-10-09

Node output

3 rows
AccountEventEventDate
A-1Login2026-10-08
A-2Login2026-10-09
A-1Reset2026-10-10