Examining Duplicate Data Rows - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

When you import data, Trillium determines which data rows are potentially a duplicate of other rows for an attribute in the entity. You access these discovered row duplicates through an attribute's Summary Data View.

To examine potential duplicate data rows

  1. In the Navigation View, click the Discover bar, then click the Entities tab.
  2. Expand the entity that contains the attribute whose duplicate rows you want to examine.
  3. Click the attribute. The Summary Data View opens for the selected attribute. (If the view does not open, click the Metadata Summaries icon on the Home tab.)
  4. Click the Content Summary tab and click Validity to expand it.
  5. Note the Value Distribution %, which indicates the distribution of distinct values. If it is not an expected percentage, there may be duplicate row values. For example, if you expect 100% distinct values (no duplicate values), and there is a Value Distribution % of 71, then there are duplicate values in the attribute.
  6. Under View Details, click Distinct Values. The Values List View opens.
  7. Examine the Frequency column. Any value greater than 1 indicates a duplicated value.
  8. Right-click a row and select Drill down to matching rows. A filtered Data Row List View of matching duplicate rows displays. Examine the rows to verify that the information is or is not a duplicate.
    Note: You can add a note to the attribute to describe the issue. You can also export the information, either to a file on your system or to the server where it can be submitted as an input file to a Quality data module for processing. See Saving Data in List Views.