Guide · updated 2026-11-04
Survivor rules explained
How to choose which record to keep when several describe the same thing.
Define the key
Decide what makes records the same: an order line, an account, a customer email.
Define the order
Rank by meaningful fields (latest instant, highest version, highest priority) and finish with a unique id so ties are impossible.
Keep the losers
Report non-surviving rows as duplicates so counts reconcile and the rule can be audited.