Matching Many Records

  • Thread starter Thread starter Stewart
  • Start date Start date
S

Stewart

I have 20000 records that I need to match up with 20000+
other records. The fields are a unique personal number,
date of birth, forename, surname, gender etc...

I can't just use the line matching method as I know that a
lot of the information may have altered, so they only
might match on 4 fields or 2 fields etc...

Is there any clever way of matching on all fields, then
removing those records as matched then 5 fields removing
the ones that match perfectly etc... 4 fields 3 fields
etc...

Stewart
 
I would add another field to your tables that contains the primary key of the
other table when a match has been made. Once the new field (AlreadyMatched) is
filled you can remove it from the match process and try a less restrictive match
until you end up with as many of your records matched as possible.

There is no "clever" way that I am aware of that will allow you to do this in
one step.
 
Back
Top