Checking Dependency

Use the dependency checking function to check the relationships between columns.

To check dependency between the PATNO and GENDER columns:

Procedure

  1. On the toolbar, click Data > Check dependency.
  2. In the "Column dependency" dialog, drag PATNO from the Column Name area to the Key column(s) area.
  3. 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.
  4. Click Analyze Dependency.

Result

The ID of the rows that are not uniquely determined by the columns are displayed.