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:

 

ANATEL~3_img576

 

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.

 

 

ANATEL~2_img8

Pre-requisite

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