Matching fields

[Former Member]

Dear Experts,

Ihave two field in which I have following values

Product Code Manufacturer

1000 Maxdata Ltd.

1000 Maxdata Ltd

1000 Maxdata

I have created the transformation which are are as belows

Field : Manufacturer

Token : To value has nothing

FROM TO

Ltd.

Ltd

In rules I have given below details

Fields Product Code & Manufacturer

Success : 100

In strategies I have mentioned

MaxScore : 100

High Threshold : 45

Low Threshold : 30

When I do the matchingusing selected vs selected. I get the score for 1st row 100 , for 2nd row 100 but I am getting

score 66 for 3rd row i.e. 1000 Maxdata.

I want to find out the reason how it calculated score as 66 and why not 100.

Thanks,

Kiran

[Former Member]

Thanks Mandeep & Christian

[Former Member]

Hi Kiran,

This is because you have two tokens for 3rd record that is 1st token as 1000 and 2nd as MaxData.

For complete understanding how it works, please refer given below both blogs: Equals Vs Token Equals

/people/mandeep.singhsaini/blog/2010/08/24/matching-merging-equals-vs-token-equals-part-1

/people/mandeep.singhsaini/blog/2010/08/24/matching-merging-equals-vs-token-equals-part-2

Regards,

Mandeep Saini

[Former Member]

Hi Kiran,

if you use Token Equal, MDM compares each token in a string, i.e. if you match "1000 Maxdata Ltd." (3 tokens) against "1000 Maxdata" (2 tokens), you will get a 2/3 matching. 2/3 of 100 equals 66.

Hope that helps.

Best regards

Christian