Delete Duplicate Rows

Multiple files

Remove duplicate rows from a dataset, keeping first occurrence

Inputs
dataset
Outputs
dataset

Overview

Removes rows from dataset A whose key already appears in reference dataset B — a cross-dataset 'delete duplicates'. Rows in A with no match pass through.

Fields

FieldDescription
Dataset A (to clean)requiredWhich variable to use as the dataset to clean.
Dataset B (reference)requiredWhich variable to use as the reference dataset.
Output variable namerequiredName this node's result so downstream nodes can select it. Auto-suggested; edit freely.

Try it

Open the node's real configuration, run it on the sample below, and see the result. Nothing is saved.

Sample input · data

email
a@x.com
b@x.com
c@x.com

Sample input · reference

email
b@x.com

This is a live preview — the sample and results are temporary and never saved.