Matching MULT_UNCERT

[dalecooper]

Hi

Unduplicate match used.

I have the following blocking column:
MatchPrimaryWord1NYSIIS : PALY

And the follwing match command:
MULT_UNCERT on field MatField1
0.9
0.1
900

It matches the following records in the MatField1:
SUBRAYAN PILLAY
SOOBRAMONEY PILLAY

The output I need is for QS to only match records when the order might differ but the word should be the same. Example : JOHN DOE and DOE JOHN should be a match but not JOHNN DOE and DOE JOHN

What am I doing wrong?

Thanks
Dale

[JRodriguez]

DaleCooper,

Take a look at your cut off value. Is the cut off value too low?

If the cut off value is properly set then, give it a try with a higher m probability, let's say 0.95 or 0.99

The column gets a higher penalty when disagreeing, the full disagreement weight will be assigned, resulting in a no match




Thanks

[ray.wurlod]

Try using a CHAR match. I suggest this because your requirement is that the words must be the same. An upstream Standardization will have placed main name and first name into the correct buckets, overcoming the order problem, and generated the NYSIIS value on which you're blocking.

[dalecooper]

Thank you for the feedback! I'm marking this as resolved.