Use the dependency checking function to check the relationships between columns.
To check dependency between the PATNO and GENDER columns:
Procedure
On the toolbar, click
Data > Check dependency.
In the
Column dependency dialog, drag PATNO from the
Column Name area to the
Key column(s) area.
Drag GENDER 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.