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, that is, if a value in a column is uniquely decided by values in another column or other more columns.

Procedure

  1. On the project page, click the icon before the flag icon in the first row, and then click Check dependency.
  2. Drag a column to the Key column(s) panel. This column acts as a key.
  3. Drag a column to the Value column 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.