GoldMine has really good duplicate checks on the entry of new records (checking on one or combination of fields) and also the merge-purge feature. Here's a quick SQL Query you can run in GoldMine (go to your Filters and Groups, and click on the SQL Query Tab) to check on duplicate Company Records.
select company from contact1 group by company having count(company)>1
If the query finds any, then use GoldMine's Merge Purge feature to remove them.
NOTE: Keep in mind that there are some organizations that prefer to have Duplicate Company Records, for example; companies with different office locations, they may create multiple contact records for the same company, with different address information.
March 24th, 2011 at 6:09 pm
Late Response, but this was handy! Thanks. What makes this even handier?
So say you import a new list and the source is unique and identifies the group:
select company from contact1
where company in (select company from contact1 where source =’Input Your Source Here’)
group by company having count(company)>1
This will find all the companies that exist in your import that already existed in GM, then the same can be done for phone1 or domain, or you could run all three queries, add the members to one group, then run the murge purge wizard!
Definitely makes Goldmine dup checking faster!