Master Data Management

 View Only
Expand all | Collapse all

QXNM comparison is showing Name token reverse as Partial , is there any way I can change mcc to E ?

  • 1.  QXNM comparison is showing Name token reverse as Partial , is there any way I can change mcc to E ?

    Posted Wed May 12, 2021 08:50 AM
    So if I have a name Bradley|Paul vs Paul|Bradley I want the mcc to show as E, but currently its predicting it as P, is there any configuration I can modify to switch the behavior ?

    Regards
    Sooraj

    ------------------------------
    sooraj subramanian
    ------------------------------

    #MasterDataManagement


  • 2.  RE: QXNM comparison is showing Name token reverse as Partial , is there any way I can change mcc to E ?

    Posted Wed May 12, 2021 11:36 AM
    Sooraj,

    QXNM should be returning an E so long as those are the only tokens being compared.  Is there a Middle Name, Suffix, or other difference that you see in the data?

    If the only two tokens are the First Name and Last Name, your MCC should show Exact, even when they are swapped.  The trick is try going to the Compare in Inspector, if using MDM SE, and run a Compare.  The detailed breakout that has an "i" will show you where the partial is happening.

    QXMN is designed to forgive field placement.  So my name, which is misplaced all the time "Tyson|Carter" vs. "Carter|Tyson" would give an mcc=E if those were the only data elements used.  If there were middle names or suffixes that disagreed, then you would get an mcc=P for partial.

    ------------------------------
    Tyson Carter
    ------------------------------



  • 3.  RE: QXNM comparison is showing Name token reverse as Partial , is there any way I can change mcc to E ?

    Posted Thu May 13, 2021 02:01 AM
    I have tried comparing these token on inspector all I have is just firstname and lastname with no middle or suffix. still its is showing as partial.

    Example:

    Bradley|Paul vs Paul|Bradley 

    Bradley = Bradley =Equal
    Paul = Paul = Equal
    mcc=P

    Is there any variable in wgtsval or bucketing function that need to modified to change the behavior ?


    ------------------------------
    sooraj subramanian
    ------------------------------