Examining a Soundex - trillium_discovery - trillium_quality - 17.2

To examine soundexes

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 Soundexes Distribution.

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

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

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

7. Examine the Soundexes List View.

   List-view columns

   Column Name	Description
   Soundex	Soundex code for the value.
   Value Count	Number of values that match the soundex code.
   Frequency	Frequency of the soundex; how many times the soundex value occurs in the attribute.
   Dist %	Percentage of rows in an entity that contain values matching this soundex. Dist % means distribution (in percents) of the soundex value across the attribute.

To list soundex values

1. In the Soundex List View, select one or more soundex rows.
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 soundex code(s) you highlighted.

To examine suspicious soundexes

1. In the Soundex List View, sort by Value Count in descending order.

   The list shows you all soundexes that have more than one value associated with it.

2. Double-click any row that displays a soundex code you want to examine.

   The Values List View displays.

3. Examine the values in the attribute that match the soundex 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 Values List View for a soundex, sort by Value to group all values that have the same soundex code.
2. Select the rows you want to investigate by highlighting them.
3. Right-click the selection and select Drill down to matching rows.
4. Examine the rows that match the values you selected.