4 Replies Latest reply on Nov 13, 2013 4:24 PM by FrankBurkhart

Not finding duplicates

FrankBurkhart Nov 13, 2013 1:01 PM

Title

Post

I'm creating a new database, so far 7 records imported from a csv file. First field is orderid which has duplicate values. Performed a find with the ! operator and FileMaker found no duplicates. Tried a second field (name) which also had duplicates, again nothing found by FileMaker. Same result when I created a calculation field and also when I created a text field and manually entered duplicate values. What is set wrong?

Thank you, Frank

1. Re: Not finding duplicates

philmodjunk Nov 13, 2013 1:08 PM (in response to FrankBurkhart)

After performing the find, did you sort the records so that the records with values were adjacent to each other?
Like Show 0 Likes(0)

Actions
2. Re: Not finding duplicates

FrankBurkhart Nov 13, 2013 1:12 PM (in response to FrankBurkhart)

Yes. Sorted before and after in table view. I have attached a screen shot of the data - after looking for duplicates.
Like Show 0 Likes(0)

Actions
3. Re: Not finding duplicates

philmodjunk Nov 13, 2013 4:20 PM (in response to FrankBurkhart)

Duplicate values in which field?

Or are you trying to find records where the values in ALL the fields are matching duplicates? The ! is intended to find records with duplicate values in a single field so if you are trying to find records where all the field values match, you'll need to use a different method.
Like Show 0 Likes(0)

Actions
4. Re: Not finding duplicates

FrankBurkhart Nov 13, 2013 4:24 PM (in response to FrankBurkhart)

     Mea Culpa - after much re-reading and finally getting it through my head. The ! operative finds records with duplicates - I kept thinking it was supposed to find unique. I wrote the necessary script to find unique records once I had identified the duplicates. It's working now. Thank you for your time and patience.
Like Show 0 Likes(0)

Actions

Go to original post