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

    Find and Delete Duplicates

    SchoolData

      Title

      Find and Delete Duplicates

      Post

           http://help.filemaker.com/app/answers/detail/a_id/3441/~/finding-and-deleting-duplicate-records-in-filemaker-pro

           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.

      Screen_Shot_2013-09-17_at_2.48.13_PM.png

        • 1. Re: Find and Delete Duplicates
          philmodjunk

               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.