How do I find source identifiers that collapse onto the same normalised key?
Comparison trims spaces, lowercases text and removes dashes and underscores. Review each collision before merging records.
Open Key Collision InspectorTry the worked example
These are the example inputs from Key Collision Inspector. Replace them in the tool to run your own case.
| Source row ID | Raw key |
|---|---|
| A1 | A-34 |
| A2 | a_34 |
| A3 | B22 |
Example result
1 collision group
Who uses this?
Data steward. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Find source identifiers that collapse onto the same normalised key. The creator describes separating work by customer and using a checked delivery procedure. Benchcraft designed this tool’s inputs, decision rule and example for this office task.
Original video