ambacti
Explore workflows

RECORD LIST COMPARISON · Workflow idea

See what changed when two versions of a list do not match.

Bring two lists of records together and compare the details for each shared item. See which entries appear only on one side, which match, and which have different values so a person can focus on the meaningful differences.

Make it yours See how it works ↓
A Roman aqueduct taking shape from architectural sketch to marble.
A little structure. A clearer outcome.
Starts with
Two lists ready to compare
Produces
A set of comparison groups that makes one-sided records, matching entries, and differing values easy to inspect.
Category
Data

01 / The starting point

A clear request.
A useful direction.

A pair of structured record lists with a field they have in common

“Compare the two lists using their shared identifier and group records that appear in one list only, match in both, or differ in their details.”
An example request · Make it specific to your team.

02 / The work

5 tasks.
One useful outcome.

Helps a person understand how two versions of structured information relate without reading every row in both lists side by side.

  1. Choose the two lists to compare

    Select the current and reference lists and make sure each represents information that can fairly be compared.

  2. Identify the shared record field

    Choose the value that identifies the same item in each list, such as a unique product or account reference.

  3. Find records unique to either list

    Review items present in the first list only and items present in the second list only.

  4. Separate matching and changed records

    Distinguish entries whose selected details agree from entries whose values differ.

  5. Resolve uncertain matches

    Check missing, repeated, or inconsistent identifiers with the data owner before treating a difference as a real change.

03 / The result

Something useful.
Something to build on.

A set of comparison groups that makes one-sided records, matching entries, and differing values easy to inspect.

AmbactiWorkflow folio · 5 steps

Find differences between two record lists

Data · Example outcome

The handoff

A set of comparison groups that makes one-sided records, matching entries, and differing values easy to inspect.

Keep in mind

The comparison depends on a reliable shared identifier and consistent field meanings. Review the match criteria and check records with missing or repeated identifiers before deciding what the differences mean.

04 / Make it yours

Set the brief.
Set the standard.

A few choices shape the work around your team.

Select the lists and fields in scope

Choose which two sets of records to compare and which details matter for this review.

Choose a dependable matching field

Use a shared identifier that distinguishes one record from another in both lists.

Decide how to handle incomplete records

Agree what should happen when an identifier or comparison value is blank, repeated, or formatted differently.

Try matching and changed examples

Check a matching pair, a value that changed, and a record appearing on only one side to confirm the groups are useful.

Put your next idea to work.

Start with your brief. Make the process your own.

Explore more workflows ↗