1 Reply Latest reply on Jan 31, 2011 1:09 PM by philmodjunk

    Merge duplicates script.

    ultranix

      Title

      Merge duplicates script.

      Post

      I want to create a script to merge duplicates.

      I made a merge database of 3 contact databases I have, each of them have different data and all are imported into one solution. I even duplicated name fields, in order not to automatically replace data that I might use.

      Here's what it looks like

      DB       ID        NAME            PHONE    EMAIL                NAME2              COMPANY   POSITION  NAME3              BIRTHDATE

      CONTA 01  John Thompson   8-88888 john@gmail.com 

      JOB     01                                                                 John Thompson Company   CEO

      DOB    01                                                                                                                        John Thompson 1950-02-01

      Note, that not all the records are present in CONTA, JOB or DOB databases. So It

      1) first of all check if ID is repeated in database more than once,

      2) then Set fields from 2nd and 3rd rows, that they all were in one record.

      3) Remove 2nd and 3rd (duplicate) rows.

      As I'm not experienced with loop-type scripts, It would be great if somebody shared a script from the start till the end. Thanks.

        • 1. Re: Merge duplicates script.
          philmodjunk

          If your ID numbers are solid, Try importing from the first table, then use Import with "update matching records in found set" and the add remaining records as new records options to merge your data. You'd set up your ID field as the "match" field to match records in your current found set to the imported data. (Show all records before you do this so that you match your imported records to all data in the table.)