Examining Metaphones - trillium_discovery - trillium_quality - 17.2

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.

   Explain list-view columns…

   Column Name	Description
   Metaphone	Metaphone code for the value.
   Value Count	Number of values specific to the metaphone code.
   Frequency	Frequency of the metaphone; how many times the metaphone pattern occurs in the attribute.
   Dist %	Percentage of rows in the attribute that contain patterns matching this metaphone. Dist % means distribution (in percents) of the metaphone pattern across the attribute.

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.

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. 

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 Value Count 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.