Tool Gate · How it works
How the Entity Identity & Functional-Key Sweep gate works
How the Entity Identity & Functional-Key Sweep grades 8 candidate record pairs on 5 weighted identity signals — DISTINCT, SAME ENTITY, or IDENTITY CONFLICT — with a disqualifier gate: the sweep reads the worst pair, so 2 conflicted pairs read IDENTITY CONFLICTED even at 68/100 average evidence.
How the gate works
This tool grades candidate duplicate-record pairs against five weighted identity signals. It reads 8 pairs and rolls them into one verdict — the worst, never the average — and then a gate that can only make it worse.
The 8 pairs
| Pair | Verdict |
|---|---|
| P-04, supplier SUP-2210 vs SUP-2211fix first | IDENTITY CONFLICTevidence 90/100 |
| P-01, supplier SUP-4471 vs SUP-9930 | IDENTITY CONFLICTevidence 88/100 |
| P-02, supplier SUP-4471 vs SUP-9931 | SAME ENTITYevidence 88/100 |
| P-05, customer CUS-3390 vs CUS-3391 | SAME ENTITYevidence 100/100 |
| P-07, contact CON-5501 vs CON-5502 | SAME ENTITYevidence 60/100 |
| P-03, customer CUS-1180 vs CUS-6042 | DISTINCTevidence 40/100 |
| P-08, contact CON-6120 vs CON-6121 | DISTINCTevidence 55/100 |
| P-06, customer CUS-7702 vs CUS-8814 | DISTINCTevidence 25/100 |
The verdict bands
A disqualifier - two different values for an identifier that's unique by definition, or a fact the two records can't both hold - only fires on a pair the evidence already reads SAME ENTITY at 60 or above. But when it fires, that pair becomes IDENTITY CONFLICT and blocks the whole sweep, no matter how high the mean evidence score runs.
In the worked sample it reads IDENTITY CONFLICTED — Three pairs read DISTINCT and three read SAME ENTITY - work waiting to happen, not a problem. But P-04 and P-01 both clear the 60-point evidence threshold and each fires a disqualifier: a functional key that's unique by definition, and a fact the two records can't both assert. Mean evidence across all eight pairs sits at 68/100, but the sweep reads the worst pair, not the mean, so it's IDENTITY CONFLICTED. The one thing to fix first: P-04, supplier SUP-2210 vs SUP-2211 - a fact the two records assert that cannot both be true of one entity; resolve the contradiction before considering a merge..
Common questions
Can every pair look survivable on the How the Entity Identity & Functional-Key gate works and the company still read IDENTITY CONFLICTED?
Yes. The roll-up takes the worst of 8 pairs — never the average — then a worsen-only gate, the Disqualifier gate gate, escalates when trouble clusters. In the worked sample it reads IDENTITY CONFLICTED because three pairs read DISTINCT and three read SAME ENTITY - work waiting to happen, not a problem. But P-04 and P-01 both clear the 60-point evidence threshold and each fires a disqualifier: a functional key that's unique by definition, and a fact the two records can't both assert. Mean evidence across all eight pairs sits at 68/100, but the sweep reads the worst pair, not the mean, so it's IDENTITY CONFLICTED.
What is a worsen-only gate?
A dispositive rule that can only lower a verdict, never raise it. One fatal flaw overrides an otherwise-set of survivable lines, because a single disqualifying gap shouldn't hide behind an average of the healthy ones. The tool also names the one thing to fix first — here, "P-04, supplier SUP-2210 vs SUP-2211 - a fact the two records assert that cannot both be true of one entity; resolve the contradiction before considering a merge.".
Grades the record pairs you paste in. Not legal or compliance advice, and it merges nothing on its own.
Embed this diagram
Free to share and embed with attribution (CC BY 4.0) — keep the link to redhub.ai.
Interactive — renders the live diagram
<iframe src="https://redhub.ai/visuals/tool/entity-identity-functional-key-sweep.html" title="How the Entity Identity & Functional-Key Sweep gate works — RedHub AI" width="760" height="1944" loading="lazy" style="border:0;width:100%;max-width:760px"></iframe>
<p style="font:14px/1.5 system-ui,sans-serif"><a href="https://redhub.ai/visuals/tool/entity-identity-functional-key-sweep">How the Entity Identity & Functional-Key Sweep gate works</a> — by <a href="https://redhub.ai">RedHub AI</a>, the AI that tells you when to doubt it.</p>Image + link — a static picture for any blog
<a href="https://redhub.ai/visuals/tool/entity-identity-functional-key-sweep"><img src="https://redhub.ai/visuals/tool/entity-identity-functional-key-sweep-share.png" alt="Diagram of the Entity Identity & Functional-Key Sweep: eight record pairs rolled up worst-not-average, a disqualifier gate, and the sweep reading IDENTITY CONFLICTED." width="760" loading="lazy" style="max-width:100%;height:auto;border-radius:16px"></a>
<p style="font:14px/1.5 system-ui,sans-serif"><a href="https://redhub.ai">RedHub AI</a> — the AI that tells you when to doubt it.</p>
This is how Entity Identity & Functional-Key Sweep works. More diagrams in the Visual Field Guide.