Identify Duplicate examples

User: "aliasgarscool"
New Altair Community Member
Updated by Jocelyn

Hi,

 

I've a data in which I want to identify duplicates (unlike remove duplicate i want duplicate fields)

 

For example I've below data 

Month                Name                         Amount

Jul-15                John                           10$

Aug-15              Alex                            15$

Sep-15             John                             5$

Jul-15                John                           10$

 

 

if the above table is my input then i want only below in my results

Month                Name                         Amount

Jul-15                John                           10$

Jul-15                John                           10$

 

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "dr-connie-brett"
    New Altair Community Member
    Accepted Answer

    If you don't actually need the duplicated examples, but rather need the count of how many times they appear this is how I would handle it:

    1 - aggregate the table  (Aggregate operator - group by all attributes and count on one of them)

    2 - filter examples for all count(attribute) > 1

    Screen Shot 2016-09-25 at 9.59.00 AM.png

    I'm assuming since there is no unique identifier you are ignoring you don't really need the duplicates the number of times they appear, but it might be useful to know how many times they appear!