Former Member

### BODS Match Transform- Conditional Matching

Hi

Can you perform use of match Transform based upon conditions? for example

if Certain Field='X', them match Critiera, Name1=90% , Post code field=100%,

if Certain field= 'Y' then Match Criteria Name1= 80% match, Post code= 60 %

Break key is same in both the cases

Can we achieve this result by using one Base_match transform?

10|10000 characters needed characters exceeded

Sep 25, 2017 at 07:00 AM

I would solve with a Case transform and 2 Match transforms.

10|10000 characters needed characters exceeded
• Former Member

Thanks Dirk!

• Former Member
Oct 05, 2017 at 02:26 PM

Hi- I am stuck in a problem statement using Match transform where I want the match transform to ignore a fields contribution if that field is blank or null in a match group. I am using Weighted mean and giving contribution to Match Criteria Fields.

I am using three fields in the Match Criteria

1) Telex- Match Score: 101, No match Score: 93, Contribution: 17%

2) Name: Match Score 101, No match Score -1, Contribution: 44%

3) Address: Match Score 101, No Match Score-1, Contribution: 39%

My weighted mean score is set to 60%,which means any Match group having a match score more than 60% will be a duplicate. What I want is if I have 2 duplicates in a group where one of the records have Telex blank and other is populated, Match transform should Ignore 17% contribution given on telex for that Match group.weighted-mean.pngaddress.pngname.pngtelex.png

weighted-mean.png (20.4 kB)