Examining Metaphones - 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

If you have an attribute that has a large number of values compared to the number of metaphones, this is an indication that you may have multiple misspelled values.

Before you can determine whether a value is correct or not, you may first need to examine entity rows and understand the context of a value.

Note: Metaphone analysis is not available for numeric values and non-ASCII encoded data.

View Metaphones

To view metaphones

  1. In the Navigation View, click the Discover bar, then click the Entities tab.
  2. Expand the entity with which you want to work.
  3. Click the attribute with which you want to work.

    The Summary Data View for the selected attribute opens.

  4. Click the Content Summary tab and click Metaphones Distribution.

    The Top 5 Metaphones pie chart displays, showing the 5 metaphones that occur the most in the attribute, and a section that represents the total percentage of all other metaphones found. (If no chart displays, the attribute has no metaphones.)

  5. Click Validity, and note the Metaphone Count. (If you do not see this metadata, the attribute has no metaphones.)
  6. Click Metaphone Count.

    The Metaphones List View opens. (You can also click the Top 5 Metaphones pie chart to open this List View.)

  7. Examine the Metaphones List View.

Examine Metaphone Values

To examine metaphone values

  1. In the Metaphones List View, select one or more metaphone values.
  2. Right-click the selection and select Drill down to matching values.

    The Values List View opens.

  3. Examine the data values that match the metaphone code(s) you selected.

Examine Suspicious Metaphones

To examine suspicious metaphones

  1. In the Metaphones List View, sort by Value Count in descending order by right-clicking and selecting Sort > Descending.

    The Value Count column shows all metaphones that have more than one value associated with it.

  2. Double-click any row that displays a metaphone code you want to investigate.

    The Values List View opens.

  3. Note the values in the attribute that match the metaphone code you selected.
  4. Examine the displayed values for typing errors, misspellings, or duplicates. 

Examine Matching Rows

To examine matching rows

By looking at matching rows, you can discover misspellings, different name or value conventions, typing errors, and other inconsistencies in attribute values.

  1. In the Metaphones List View, sort by ValueCount to group all values that have the same metaphone code.
  2. Select the rows you want to investigate by highlighting them.
  3. Right-click the selection and select Drill down to matching values.
  4. Right-click the rows you want to further investigate and select Drill down to matching rows.
  5. Examine the rows that match the values you selected.