Merging record data in the same table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with duplicate "company" records. The company names have
varying values. I am trying to "merge" the data from company name record2,
"Off_Manager" field into the company name record1. I would like to do a
batch merge of 750 records. Anyone have some recommendations vs doing them 1
at a time?

Thanks,

Co_Name Off_Manager CFO FIRST NAME CFO LAST NAME
3M Patrick Campbell
3M, Inc. Shawn McDonald
AMD Hector de Ruiz
AMD, Inc. Kate Sebrant
 
I have a table with duplicate "company" records. The company names have
varying values. I am trying to "merge" the data from company name record2,
"Off_Manager" field into the company name record1. I would like to do a
batch merge of 750 records. Anyone have some recommendations vs doing them 1
at a time?

Thanks,

Co_Name Off_Manager CFO FIRST NAME CFO LAST NAME
3M Patrick Campbell
3M, Inc. Shawn McDonald
AMD Hector de Ruiz
AMD, Inc. Kate Sebrant
Click to expand...

This can be REALLY tough. Sure, 3M and 3M Inc. are the same company...
but is J. C. Watson the same company as Watson Produce Inc.? (No, as a
matter of fact: J. C. quarreled with his son who founded his own
company). "Similar" names match for human intelligence but are
difficult to match automatically.

An Update query would be the ticket if you can find some way to join
the records, but I fear that any attempt to automate the process will
risk updating the wrong record, *and* failing to update some of the
right records!
 
Back
Top