Siebel Data Quality Administration Guide > Configuring and Using Data Matching >

Merging Duplicate Records


Duplicate records can be merged using the Merge button or the Merge Records option from the menu list. There is a difference between these two types of merging operations:

When multiple records are merged, the child and grandchild records associated with the nonsurviving record or records are associated back to the surviving record.

When records are merged using a sequence merge, the following events take place:

For example, the number in the Sequence field is used when you want to merge multiple records into one record. If one field of the master record is empty, the Merge button copies the value to the master record from the other records that are going to be merged. The Sequence number prescribes the order of field values to pick from. It is especially useful if many fields are empty, such as when a contact record with a Sequence of 1 has a value for Email address, but its Work Phone # field is empty, and a contact record with a Sequence number of 2 has a value of Work Phone #. If the field Email address and Work Phone # in the retained record are empty, then the value of Email address is picked from sequence number 1 and the value of Work Phone # is picked from record of sequence number 2.

NOTE:  The retained record is based on the last record you selected using the keyboard or mouse, not the Sequence number entered. The Sequence number indicates only the sequence in which null fields should be populated from the losing records to the winning record.

To merge duplicate records

CAUTION:  Merging records is an irreversible operation. You should review all records carefully before initiating this function.

  1. Click the resolution view tab for the type of record you have selected.
  2. For example, if you have selected an Account record, click the Duplicate Accounts Resolution view tab.

  3. If two records appear to be duplicates, enter a sequence number in the Sequence field for each record.
  4. The last record selected is retained after the merge. Missing fields in the retained record are populated in ascending sequence number order from corresponding fields in the remaining record.

  5. Edit the records, if necessary.
  6. Click Merge.
  7. The two records are merged to produce one new record.


 Siebel Data Quality Administration Guide 
 Published: 15 May 2003