Shapes

Filter and organize records

Compare data sets

Compares this step's records with another step's and tags each as inserted, deleted, updated or unchanged.

Nodes › LogicOpen in Neblex
Good for
Finding what changed
Role
Works on the records in a flow
Find it in
Nodes › Logic

When to use it

  • Today's export should be compared with yesterday's to send only the changes.
  • A destination should be reconciled with its source.
  • Deleted records must be found even though nothing reports them.

Reach for something else when

Example

Compare today's product export with yesterday's by sku and send only the inserts and updates to the shop.

  1. Schedule
  2. Compare data sets
  3. Branch
  4. Shopify

How it works

Settings
Compare with step; Key fields that identify a record; Fields to compare (empty compares every field); Also pass on unchanged records.
Output
One record per key on either side, tagged _change: insert (only here), delete (only in the other step), update (with _changed listing the fields that differ) or unchanged. Connect a Branch on _change to handle each kind. Any number of records works.
Example
Compare today's product export with yesterday's by sku and send only the inserts and updates to the shop.
More in the guide

Add it to a flow

  1. Open the flow from Build › Workflows.
  2. Open Nodes and find Compare data sets under Logic, or search for it. Click it or drag it onto the canvas.
  3. Drag from the previous step's output handle to its input, then open its settings with ✎ Edit.
  4. Run the flow and click the step to see the records it received and produced.