Benchcraft / Data bench
Data integrity   /   Data steward

Key Collision Inspector

Find source identifiers that collapse onto the same normalised key.

01 / Inputs

Working sheet

Edit any cell to recalculate. Use anonymous references. Data stays in this browser tab and clears when you reload.

Source row IDRaw keyRow
02 / Review

Decision sheet

Normalised keySource rowsRaw valuesDisposition
a34A1, A2A-34 / a_34Review together
b22A3B22Unique
How the rule works

Comparison trims spaces, lowercases text and removes dashes and underscores. Review each collision before merging records.

Read the worked example

Optional paid service

Request a custom workflow

€149 one-time pilot after written scope agreement. JB Codex adapts one repeated job with a worked example and owner review.

The free tool runs independently on your device.