Resolving Duplicate Records - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
Topic type
How Do I
Overview
Tips
Reference
First publish date
2007
ft:lastEdition
2024-03-04
ft:lastPublication
2024-03-04T22:52:13.486265
Duplicate resolution exceptions occur when the Spectrum Technology Platform cannot confidently determine whether a record is a duplicate of another. There are three ways to resolve duplicate records.
Note: Duplicate records can only be resolved with the Resolve Duplicates function on the Tabular view. However, you can still edit those records in the Form view.
Note: If you are working with Duplicate records in an Approval flow, see the section on Approval Flows.

One approach is to group duplicate records together into collections. When you approve the records they can then be processed through a consolidation process to eliminate the duplicate records in each collection from your data.

Another approach is to edit the records so that they are more likely to be recognized as duplicates, for example correcting the spelling of a street name. When you approve the records, Spectrum Technology Platform reprocesses the records through a matching and consolidation process. If you corrected the records successfully, Spectrum Technology Platform will be able to identify the record as a duplicate.

Yet another approach to resolving duplicate records is to create a best of breed record. This combines the other two approaches by managing record collections and then editing one of the records in the collection to include fields from both the original and duplicate records. This record is then known as the best of breed record.