cancel
Showing results for 
Search instead for 
Did you mean: 

mdm comparison between empty and filled fields

0 Kudos

Hallo MDM experts,

During a matching phase we would like to compare fields that they can be filled or not.

At the moment the comparison result between a filled field and an empty field is managed by the undefined value in the rule properties.

This value is valid also for the comparison between an empty field and an another empty field.

I would like to manage this comparison between empty-empty fields with the success value leaving the undefined value only for the comparision of filled-empty fields

Is anyone facing the same challenge?

Thank for any help.

SB

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

During a matching phase we would like to compare fields that they can be filled or not.

Matchind is use to identify duplicates not to check fields that they are filled or not. For checking that fields are filled or not you have to write Validation.

During matching suppose you make Transformation of field say Name and include this transformation into RULE where you suppose give Success = 90, failure = 10 and undefined = 0 and further include this RULE into Strategy. you have 5 records like this into data manager for field Name say:

Name

1. Test

2. Test

3.

4. SB

5.

in which records 3 and 5 having empty Name field. So, on execution this strategy. you could get score for records as

Count Level Score

1 High 90

1 High 90

0 None 0

0 None 10

0 None 0.

Here you could indentify records 1 and 2 are duplicates. But records 3 and 5 will not consider duplicates as its field Name having empty values. thats why we Undefined = 0 for empty records. This is how Matching Mode works.

Hope it will help you,

Rewards if useful.....

Mandeep Saini

Answers (2)

Answers (2)

Former Member
0 Kudos

It's not possible to get a "match" result in comparing empty fields. Try it with a workaround:

With an assignment fill all NULL fields with a value, e.g. "NULL".

Create a rule with a transformed field where you delete this value in order to be able to get "undefined" match rates.

Create another rule where you use the not transformed field to get a match rate for NULL=NULL and VALUE=VALUE

Combine these rules in a strategy.

Regards

Jutta

Former Member
0 Kudos

Hi,

our goal is to assign two different scores in case of

-comparison between filled field and empty field;

-comparison between empty field and empty field.

Can we do this using success, failure and undefined values into rules or using anyone else method?

Thanks.

Regards.