Follow our news:

Follow canonburysvcs on Twitter Follow Canonbury Services on Facebook Follow Canonbury Services' news by RSS Follow Canonbury Services' news by Atom Follow Canonbury Services' news by email


Script to find duplicate records

17/01/2012 – in SQL queries

Here is a very simple SQL script that you can run in GoldMine to find duplicate records.

select * from contact1 as c1a, contact1 as c1b where and and
order by,

As it stands it looks for matches in the company and contact fields but, obviously, you could amend this to include any fields that you like.

Having found them, you could then select particular records in the Contact Search Centre and merge them manually, or you could create a group from the results set and use the merge-purge wizard to process them all.

As always though, the recommendation is to take a backup before doing any kind of data manipulation!