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
- Recode data values
- Generate and export recode value look-up tables to be used in the Quality Transformer process
Total count of unique values in a data source
To see the total count of unique values in a data source
- 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.
-
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.
- 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
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.