As a data owner, you can review and process data quality assessment results.

For each record with possible duplicates, you can:

  • Review the found duplicates.
  • Merge field values from the duplicate records to a chosen master record.
  • Manually delete undesired duplicate records.

Both basic and fuzzy duplicate checks are done by the quality assessment. You can review and merge found duplicates for both duplicate check types in the same way.


Standard procedure

1. Go to Data quality studio > Inquiries > Quality assessment exceptions log.
2. In the list, find and select the desired record with review status 'In progress', and which message says that possible duplicates exist.
3. Review the possible duplicates that are found by the data quality assessment.
  Click View possible duplicates.
4. Sub-task: Merge field values of duplicate records.
  4.1 You can merge field values of the found duplicate records to a chosen master record.
  In the Duplicates found section, click Proceed to merge.
  4.2 The master record to which the field values are merged is shown in the Master record section.
By default, the originally selected record is the master record.
You can select another of the shown duplicate records as the master record. As a result, this record is shown in the master record section.
  For the desired record, select the Master record check box.
  4.3 The duplicate check setup defines which fields can be merged. These fields are shown in the Duplicates found section, preceded by a 'merge' check box.
Select the 'merge' check for each field value that you want to merge to the master record. You can only select one 'merge' check box for each field.
  Select the desired 'merge' check boxes.
  4.4 Click Merge.
  4.5 Click Yes.
5. Sub-task: Delete undesired duplicate records.
  5.1 When you merge field values to a master record, the found duplicate records are not deleted automatically. The main reason is that the found duplicate records can be referenced in other records.
Therefore, if desired, delete the undesired duplicate records manually.
  In Duplicates found section, in the list, find and select a duplicate record that you want to delete.
  5.2 Click to follow the link in the Identifier field.
  5.3 Click Delete.
 

Note: Before you delete a record, make sure it is not referenced in another record.

  5.4 Click Yes.
  5.5 Close the page.
6. Close the page.
7. Close the page.

Provide feedback