Match Criteria

Hi Experts,

I have been using the match wizard and am totally confused. I have created a simple match using three fields (last name, first name and middle name). I have sorted the input using the field SOURCE.

There are two values for SOURCE. My input table has a values of NEW and OLD. One record has NEW and seven others have OLD. The NEW record finds a match for records 5, 6, and 7 all of which have similar values for all three names. However the 8th record is a perfect match and yet fails to be identified as a match.

I can't understand why this is happening.

Also I have set each field to contribute to a weighted score. None the less my three partial matches all get a score of 100. Again I can't understand why they don't get lower scores.

The result set is shown below.

CLIENTPARTNERSOURCESEXNAME_LASTNAME_FIRSTNAMEMIDDLEBIRTHPLNATIOBIRTHDTset1_level1_GROUP_NUMBERset1_level1_MATCH_SCOREset1_level1_GroupStats1_GROUP_COUNTset1_level1_GroupStats1_GROUP_RANK010000001OLDMALEBrownAaronBrianAUSAUS05011970<Null><Null>1<Null>010000002OLDMALEKramerCharlieCedricNZNZ12061982<Null><Null>1<Null>010000003OLDMALECollinsCharlesCedricNZAUS05011970<Null><Null>1<Null>010000007OLDMALEJones-SmythJamieJuliusUKNZ06121948<Null><Null>1<Null>00NEWMALEJones-SmythJamieJuliusUKUK110619731<Null>4M010000004OLDMALEJonesJamesJuliusUKUK1106197311004S010000005OLDMALEJones-SmithJameyJUKUK1106197311004S010000006OLDMALEJones-SmithJamieJulianUKUK1106197411004S

Thanks

Cliff the bewildered