Skip to Content
avatar image
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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 25, 2017 at 07:00 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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

    Add comment
    10|10000 characters needed characters exceeded