Undefined

[Former Member]

Hi SDNers,

Can anybody tell me what is the functionality of undefined function in rules.

Thanks & Regards

Dilmit Chadha

[Former Member · Accepted solution]

Hi Dilmit,

While matching two records if you encounter a field which is null for one of the records or both, then the score defined in undefined is the displayed as the output score for that particular field match

Hope its helpful.......

Regards,

Dheeraj.

[Former Member · Accepted solution]

Sorry dilmit, i read rules as roles. I think Dheeraj is right.

just to mention, that field must be selected while defining Rule.

BR,

Alok

[Former Member]

Hi Dilmit,

Each matching rule is essentially a numeric scoring mechanism that

uses the specified matching function to compare field values across

record pairs during matching execution, and then return a score for the

three possible outcomes of the function:

We have give scores depending upon the success or failure.

Success We have to give the score upon sucsess

Failure We have to give the score upon failure( we can give negative value also)

Undefined We have to give the score if any field has a NULL value.

Regards,

Nikhil

[Former Member]

Hi Nikhil,

Thanks for you reply. I have created a rule which is a concatenated field and contains values from 3 different fields. Out of these 3 fields values in 1 of the field is not present for some records. So, in this case do i need to give score for undefinied field only or in success and undefined both. And in both the cases how will it effect my result.

Thanks & Regards

Dilmit Kaur Chadha

[Former Member]

Dilmit,

Give score for both. First of all Success, faliure and Undefined are measurement variables. If records matches on matching criteria, it comes sucess otherwise faliue.

Now the case of Undefined Fields:

Say we have Main Table: Test with 3 records like:

Name Code Company

Dilmit 0001 ABCDE

Dilmit blank ABCDE

Dilmit 0001 ABCDE

Our Rule is defined with match criteria Name, Code and Company.

Sucess=100

Faliure= -100

Undefined=50

Define Strategy with this Rule with High Thresold=45 and Low=30.

Now apply a Strategy with that rule by selecting these records:

You will get:

Count Level Score

2 High 100

2 High 50

2 High 100

Score 50 comes for 2nd record because we have also defined Code in match criteria and it is not defined for this record.

See in match tab, you will see -100 means faliure for 2nd record and for other two records it will be 100 for one and -100 for 2nd.

Hope it will clear your doubt.

BR,

Alok

[Former Member]

Dilmit,

What Version and Build you are using?

I am using SP06, i didn't found anything related to "Undefined" in functions of Rules. Correct me if i am wrong or please specify correct hierarchy(path).

There is only one option "Unprotect Record" which is related to security means if any other have protected any record then according to permission you can remove that protection or not.

Please tell me where is "undefined" specified.

BR,

Alok

[Former Member]

Hi Alok,

I am using SP05.

Path for undefined:

matching mode-> Rule->create a new rule-> undefined (last property to be filled)

Undefined is just below the success and faliure.

Please help if anybody has worked on it.

Thanks & Regards

Dilmit Chadha