This calculation uses the self-join relationship to compare the value of Counter in the current table occurrence to the value in the related table occurrence named Same. If ( Counter = Same::Counter "Unique" "Duplicate" ) If your database already has such a field-for example, the default PrimaryKey field-you can use that field instead of the Counter field in the calculation for the Check Duplicates field below, and you can skip step 7.Ī calculation field with a text result, with the formula: The purpose of this field is to assign a value to each record that is unique. In the Add Relationship dialog box, name the new table occurrence Same.įileMaker Pro creates a second occurrence of the table upon which you're basing the self-join.Ī text field with an auto-entered serial number (select Serial number and accept the default values for Next and Increment by). Your chosen field becomes the match field in both table occurrences in the self-join relationship. In the relationships graph, drag your chosen field from a table occurrence back onto itself to define a self-join relationship. For example, First Name & Last Name & Phone Number. If you want to check whether multiple fields taken together have duplicate values, you can create a calculation field with a calculation (returning a text result) that combines data from several fields and check the calculation field for duplicates. If you plan to delete the duplicate records that you find, make a backup copy of the file.Ĭhoose the field that you want to check for duplicate values. To find duplicate records except the first instance: Once this system is set up, duplicate records will be identified as they are created. This procedure uses a self-join relationship and a calculation field referencing the relationship to identify all duplicate records except the first instance, according to the sort order defined in the relationship. Finding duplicate values using a self-join relationship
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |