Int4 Suite Documentation

Deletion of Duplicates

USE:

Deletion of Duplicates is an optional configuration for the comparison of the tables.

Suppose you want to make sure that unique records (based on fields' value) are compared. In that case, you can select fields for value comparison here. Records will be compared one by one, and only the first record with the same value will be kept for further processing. You can define the order of the records in the Sorting Criteria configuration.

If the configuration is not maintained, no action will be performed.

EXAMPLE:

Below is a sample configuration for the VBAK table:

image2021-6-14_12-41-26.png


In this case, VBAK records will be compared by values of the BSTNK field. The only first record with the same value will be kept for comparison.

VBELN

BSTNK

ERDAT

Kept/Removed

320

Customer_PO_1

20210614

Kept for Ref/Act comparison

310

Customer_PO_1

20210610

Removed from Ref/Act comparison

300

Customer_PO_2

20210601

Kept for Ref/Act comparison