Checking Dependency

You can find duplicate data by checking the dependency of two columns.

TIBCO Clarity uses the key/value pair to check the column dependency. If a column corresponds to a unique value in another column.

Procedure

  1. On the project page, click , and then click Edit columns > Check dependency.
  2. Drag a column to the Key column(s) panel. This column acts as a key.
  3. Drag a column to the Key value(s) panel. This column acts as a value.
  4. Click Analyze Dependency to analyze the selected columns.

Example

Take the Sample-patients dataset as an example. Use the dependency checking function to the check the dependency between the GENDER and VISIT columns.

As shown in the checking result, there are two rows that are not unique.