Creating a New Group of Duplicate Records - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Product family
Spectrum > Quality > Spectrum Quality
Product name
Spectrum Data Quality
Spectrum Data Quality Guide
Topic type
How Do I
First publish date

In some situations you can create a new group of records that you want to make duplicates of each other. In other situations you cannot create new groups. Your ability to create new groups is determined by the type of Spectrum Technology Platform processing that generated the records.

  1. In the Editor, select the record you want to work on then click the Resolve duplicates button .

    The Duplicate Resolution view shows duplicate records. In this view, the initial record is highlighted in bold text. A column label is highlighted in blue text on any column of user data that contains values different from the value in the exception record. In these columns, values that do not exactly match the exception record are highlighted in blue. Keep in mind that the blue highlighting is not visible on a value when it is empty, null, or spaces. Note also that null and empty values are considered the same.

    For each record, the MatchRecordType column specifies one of three types of exceptions:

    A record that other records are compared to in order to determine if they are duplicates of each other. Each collection has one and only one suspect record.
    A record that is a duplicate of the suspect record.
    A record that has no duplicates.
  2. If necessary, correct individual records as needed.
    For more information, see Editing and resolving records.
  3. Select a record that you want to put in the new collection then click the Create new collection button .

    The new collection is automatically given a unique collection number, and the record you selected becomes a suspect record.

    Note: If you do not see the New Collection button, you cannot create a new collection for the records you are working with. You can only create new collections if the dataflow that produced the exceptions contained and Interflow Match or an Intraflow Match stage, but not if it contained a Transactional Match stage. Contact your Spectrum Technology Platform administrator if you would like additional information about these matching stages.
  4. Place additional records in the collection by entering the new collection's number in the record's CollectionNumber field.
  5. When you are done modifying the record, click Accept .
    This changes the record status to Accept. If you click Accept again, the status is changed to Pending, so that the record can be reviewed later.
  6. To save your changes, click the Save changes button.
    This changes the record status to Resolved and makes the record available for additional processing using the Read Exceptions stage.