You can compare values found across all attributes in an entity. This is useful to discover which attributes contain similar or duplicate values, and to validate joined rows.
To run a value comparison
-
In the Navigation View, right-click an entity and select Drill down to attributes.
The Entity Member Attributes List View opens.
-
Select 2 to 8 attributes, right-click, and select Compare values.
The Value Comparison List View opens. Note the following:
- The Values column shows the name of each value to compare.
- A column for each selected attribute is included. The numbers in the column indicate how many times the value occurs in the attribute.
- The Join Product column indicates whether any rows are joined.
-
To view data rows that contain specific values:
-
Select one or more rows.
-
Right-click and select Drill Down to matching rows in
entity.attribute.
The Data Rows List View opens for the selected values.