RedHub AIRedHub AI
Tool Gate · How it works

How the roll-up gate works

How the Entity Identity & Functional-Key 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 — then a gate that can only make it worse.

The 8 pairs

01P-04, supplier SUP-2210 vs SUP-2211fix firstevidence 90/100IDENTITY CONFLICT
02P-01, supplier SUP-4471 vs SUP-9930evidence 88/100IDENTITY CONFLICT
03P-02, supplier SUP-4471 vs SUP-9931evidence 88/100SAME ENTITY
04P-05, customer CUS-3390 vs CUS-3391evidence 100/100SAME ENTITY
05P-07, contact CON-5501 vs CON-5502evidence 60/100SAME ENTITY
06P-03, customer CUS-1180 vs CUS-6042evidence 40/100DISTINCT
07P-08, contact CON-6120 vs CON-6121evidence 55/100DISTINCT
08P-06, customer CUS-7702 vs CUS-8814evidence 25/100DISTINCT
IDENTITY CLEAN
every pair reads distinct
MERGES PENDING
worst pair reads same entity, no disqualifier fired
IDENTITY CONFLICTED
any pair fires a disqualifier
Disqualifier gate · worsen-only

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.

IDENTITY CONFLICTED

Why: 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. 2 of 8 pairs conflicted · worst-not-average · mean evidence 68/100.

Fix firstP-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.

No single pair is the crisis — the clustering is. The roll-up takes the worst, the gate escalates when trouble compounds, and it names the one thing to fix first. Grades the record pairs you paste in. Not legal or compliance advice, and it merges nothing on its own.