How to filter rows with duplicate values

Hi, is there a way to filter rows that have same value in certain field?

A B C D

NJ 2015 Honda I5A3HA74HANC7A32

GA 2016 Toyota H7612HSK59NK8NA

TN 2017 Toyota I5A3HA74HANC7A32

NY 2019 Ford G7HY84HA9837I0123

So, if I want to filter only the rows that have same value in column D (row 1 and 3 in this case) How do I do that? My data sample has around 500 rows and I need to filter the rows with duplicate value. If I do unique value, it only filters out one of the duplicate rows but not all

Workflow

Accepted answers

sjm

@bb how about something like the attached workflow?

Take a count for each value in Column D and then join it and then filter duplicates.

check for duplicates.yxmd

All comments

mmenth

Hi @bb,

You can do this by using a unique tool (I use two to get down to unique of the duplicates), and then join back to your original data. I don't know if you meant "filter out" or "filter to", If you want to filter out, then take what comes out of the L node, otherwise, the J node with all the right fields unchecked.

Best,

mmenth

Filter example.yxmd

CharlieS

The Unique tool can take care of this for you. In this example, place a Unique tool and check the box for column D. The rows with duplicates will out from the "D" anchor. Join these records to the original for what's called a "left outer" join.

20190318-LeftOuter.yxmd

sjm

@bb how about something like the attached workflow?

Take a count for each value in Column D and then join it and then filter duplicates.

check for duplicates.yxmd

Thank you all, that works perfectly

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703