Use the dependency checking function to check the relationships between columns.
To check dependency between the SSN column and other columns:
Procedure
On the toolbar, click
Data > Check dependency.
In the
Column dependency dialog, drag FirstName, LastName, and Phone from the
Column Name area to the
Key column(s) area.
Drag SSN from the
Column Name area to the
Value column area.
Dependency analysis tests whether one or a group of keys can uniquely determine the column in the Value field.
Click
Analyze Dependency.
Result
The ID of the rows that are not uniquely determined by the columns are displayed.