1 Reply Latest reply on Sep 17, 2013 12:52 PM by philmodjunk

    Find and Delete Duplicates



      Find and Delete Duplicates



           This article looks promising, but it does not work for me. It does not mark an X anywhere. When I use ! in Find, it returns all the duplicates and if I delete all of them, I loose the record I want. I only want to keep one record if there are two or more with duplicate values for the field. 

           I attached a screenshot of my script.


        • 1. Re: Find and Delete Duplicates

               I see a typo. Set Variable refers to a variable named $id, but your if step refers to a differently named variable: $is

               That's actually a pretty old article. It works, but another method is to import all your records into a table where you specify a validation field option of Unique values, validate always on the ID_Course field. That method will automatically filter out duplicates and does not require any script at all.