Use Case Accelerators > How to Retain Only Records with Duplicate Keys

How to Retain Only Records with Duplicate Keys

Article #: Product: Version:

Summary

In order to retain only records with duplicate keys, you can use a DMExpress Aggregate task to count the number of records with a given key, and then use a filter to output only those records whose key count is greater than 1.

Resolution

The attached example demonstrates how to retain only the records that contain duplicate keys using a DMExpress aggregate task.

Attachments

224_Retain_only_duplicate_recs.zip, compatible with DMExpress version 8.0.5 or higher

Additional Information

For more information on the summarization functions available in a DMExpress Aggregate task, see Defining the summaries in the DMExpress Help.

For an example of how to perform XSUM in DMExpress, where all uniquely-keyed records and first of duplicate-keyed records are written to one target, and the remaining duplicate-keyed records are written to another target, see How to Perform XSUM Deduplication.

Last updated: