Checking Dependency

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

This example shows how you can check dependency between the SSN column and other columns.

Procedure

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

Result

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