<< Click to Display Table of Contents >> Navigation: 5. Detailed description of the Actions > 5.6. Cleaning > 5.6.4. Keep Only Duplicates |
Icon:
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.
Pre-requisite
The input table of this action must be sorted on its primary key(s).