Benchcraft / Data bench
Operator guide / Data bench

Key Collision Inspector

Find source identifiers that collapse onto the same normalised key.

Prepare your sheet

Use one row per source row id observation. Enter Raw key. Check that every row belongs to the same review scope.

Decision rule

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

Worked result

The fictional example contains 3 input rows. Its result is 1 collision group.

Normalised keySource rowsRaw valuesDisposition
a34A1, A2A-34 / a_34Review together
b22A3B22Unique

Run it on your own inputs

  1. Open the tool and choose Start empty or edit the example.
  2. Enter the inputs, resolve validation messages and review the decision sheet.
  3. Download the text report or print the summary for the responsible person.

Open the working tool

Source and support

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. Reviewed source · The Next New Thing at 4:03.

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.