Compare Datasets

Find differences between two data sets — additions, removals, and changes.

Written By pvdyck

Last updated 18 minutes ago

The Compare Datasets node identifies differences between two sets of items connected to Input 1 and Input 2.

Parameters

Parameter	Description
Merge by Fields	The field(s) used as keys to match records between the two inputs (e.g., `id`, `email`)
When There Are Differences	What to output: Return Everything, Return Missing in Input 1, Return Missing in Input 2

The node produces up to four outputs depending on configuration:

Output	Description
In Both	Items present in both inputs (matched by key fields)
Only in Input 1	Items in Input 1 that have no match in Input 2
Only in Input 2	Items in Input 2 that have no match in Input 1
Different	Items present in both but with changed field values

Option	Description
Fields to Skip Comparing	Exclude specific fields from the difference check (e.g., `updatedAt`)
Disable Dot Notation	Treat dots in field names as literal characters
Multiple Matches	How to handle when multiple records in one input match a single record in the other