Examining Unique Values - trillium_discovery - 17.1

Trillium Discovery Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
17.1
Language
English
Product name
Trillium Discovery
Title
Trillium Discovery Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

Each attribute and row of a data source contains a set of unique values. A unique value is one that occurs only once in an attribute. One of the first steps in understanding your data is examining unique values and their corresponding rows in attributes.

This will tell you:

  • How many unique values occur in an attribute
  • Which rows contain the value
  • Which attributes contain more unique values than others

You can then

Total count of unique values in a data source

To see the total count of unique values in a data source

  1. Click View Data Sources from the navigation menu and run a data source search. The Find Data Sources Results view displays a default set of columns.
  2. Do one of the following:
    • Click Column View Options > Choose columns. The Edit Columns window opens. In the Available Columns list, double-click Values to add the column to the Included Columns list. Click Done.
    • Double-click the data source you want to examine. On the Source Metadata tab, scroll to the Values row.
  3. Note the number in the Values column. This is the total number of unique values across all attributes in the data source.

Unique values and value distribution for an attribute

To see the unique values and value distribution for an attribute

  1. Open a data source.
  2. Click the Attribute Details tab.
  3. To see unique values for an attribute, do any of the following:
    • In the Attribute Name list, click the name of the attribute you want to examine:
    • In the Values > Completeness table, note the total unique values for the attribute.
    • Click the attribute_name tab and note the value displayed in the Value column for the Unique Values metadata.
    • Click the Attribute Summary tab and note the total unique values for an attribute in the Unique Values column.
  4. Click the Values: attribute_name tab. The Distribution % column displays a percentage that indicates how unique each value in the current attribute is. The higher the percentage, the higher the number of values that occur only once, and therefore the greater the level of unique values.

Specific rows containing unique values

To see specific rows containing unique values

On the Values: attribute_name tab, double-click the row you want to examine. The Data Rows: Selected Value tab opens showing all data rows that contain the selected value.