Automatically compare two lists and flag the differences

Feed in two lists of records and instantly see what matches, what is missing, and what is only on one side.

How the work actually flows

It branches. Every path runs; all paths must finish before it continues.

Pattern: Parallel Split (2) ยท Synchronisation (3)

flowchart TD trig(("user submits two lists")):::human s0["compare records by match field"]:::task s1["sort into matched and unique groups"]:::task s2["return three organized lists"]:::task trig --> s0 s1 --> s2 gx{"+ which group does record belong to"}:::gate s0 --> gx p00["flag as match"]:::task gx -->|"matching records"| p00 p10["flag as list one only"]:::task gx -->|"unique to list one"| p10 p20["flag as list two only"]:::task gx -->|"unique to list two"| p20 jn{"+ combine results"}:::gate p00 --> jn p10 --> jn p20 --> jn jn --> s1 out[/"three organized lists returned"/]:::out pay{{"reconciles data without manual matching"}}:::pay s2 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
A stepA personEvery pathWaits for allResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
General Automation
Connects
Your existing tools

The problem it solves

When you need to reconcile two customer lists, two sets of transactions, or an old system against a new one, matching records by hand is slow and error-prone. Small typos and missed rows mean you cannot fully trust the result.

Who it fits

Operations and finance teams who regularly reconcile data between two systems or spreadsheets.

How it works

  1. You provide two lists of records and the field to match them on, such as email or ID
  2. The system compares every entry in both lists using that field
  3. It sorts results into matching records and records unique to each list
  4. You receive the three organized groups back
What you get

Records that finally line up across systems

Feed in two lists from different systems and instantly see what matches, what is missing, and what only appears on one side.

What you get

Three organized lists: matching records, and records unique to each source.

What you need

No separate account is required beyond wherever this comparison is triggered from.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Calculate shopping cart totals and apply discounts automatically

Automatically totals each shopping cart and applies a discount when the order is large enough.

Standard

Get alerted in Microsoft Teams when a site goes offline

Checks your Unifi network sites on a schedule and posts a Microsoft Teams alert the moment one drops offline.

Standard

Shorten long URLs automatically with a custom domain

Turns any long web link into a short, branded URL using your own custom domain in seconds.

Standard

Write personalized LinkedIn connection notes with AI

Reads each prospect's LinkedIn profile and uses AI to write a personalized connection request message.

Advanced
Back to the AI Playbook