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
Solved! Go to Solution.
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
@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.
Thank you all, that works perfectly