Dedup Results

When the duplicate checking is completed, you are directed to the Data page to view the Dedup results.

The Dedup results are displayed in the new added dedup columns:

Column Name Data Type Description
dedup_isLead Boolean The value indicates whether this row is the first row in a duplication group.

A value of true indicates this row is the first row in a duplication group.

dedup_group Integer The index of a duplication group:
  • A value of 0 indicates this row is a unique row.
  • A value larger than 0 indicates the number of the duplication group.
  • A value of -1 indicates the selected column values are empty.
dedup_rowIndex Integer The original row index in the project.
dedup_server_index Integer The original row index in the TIBCO Patterns table.
Note: This column is displayed only when checking duplicates against an external table.
dedup_score Integer A value (from 0.0 to 1.0) indicates the degree of similarity.