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