5.6.4. Keep Only Duplicates

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.6. Cleaning >

5.6.4. Keep Only Duplicates


Icon: ANATEL~3_img575


Function: KeepOnlyDuplicates

Property window:




Short description:

Keep only duplicate rows.


Long Description:


Let’s assume that:

We have a Transaction-table that is ready to be transformed into a “Global-Customer-Level” table.

we only want to analyze customers that have made 2 or more transactions.


In other word, all the rows of the Transaction-table that are linked to a customer that made only one transaction must be removed from the Transaction-table. This Action allows you to do precisely that.





The input table of this action must be sorted on its primary key(s).