BODS Match Transform- Conditional Matching

[ankur_k]

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?

[former_member187605 · Accepted solution]

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

[ankur_k · Accepted solution]

Thanks Dirk!

[ankur_k]

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