/
(3.10) Deletion of Duplicates
(3.10) 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:
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 |
, multiple selections available,
Related content
Deletion of Duplicates
Deletion of Duplicates
More like this
(3.10) Sorting Criteria
(3.10) Sorting Criteria
More like this
Sorting Criteria
Sorting Criteria
More like this
(3.10) Comparison details
(3.10) Comparison details
More like this
Comparison details
Comparison details
More like this
(3.10) Database Comparison Rules
(3.10) Database Comparison Rules
More like this
© 2017 - 2022 Int4 AG All rights reserved