Depending on your requirements, you can choose one of these methods to process the duplicate records:
- Select best record (default option): identifies a single record in the group as the 'surviving record'. All other records are ignored.
- Select and complete best record: identifies a single record in the group as the 'surviving record'. If there are any missing values in the surviving record, the best values from the remaining records are used.
- Merge best values: no single record is identified as the 'surviving' one; it's formed by combining the best values from each of the candidate records.
