Reltio Connect

 View Only

  • 1.  Merge lowercase and uppercase values using matchFieldURIs

    Reltio Partner
    Posted 11-17-2022 12:01
    Hi Team,
    Using matchFieldURIs, we can merge the nested records, example below.

    Configured matchFieldURIs on PhoneType
    suppose, we have 2 PhoneType with different case, supposed to merge these 2 nested values in profile
    1. HOME Phone 2. home phone
    Is it possible to merge these nested values?

    ------------------------------
    Nagaraju
    PwC
    ------------------------------


  • 2.  RE: Merge lowercase and uppercase values using matchFieldURIs

    Founding Member
    Posted 11-18-2022 09:39

    Hi Nagaraju,

    To my knowledge matchFieldURIs are case sensitive however for your example if Phone Type is configured in RDM then you can enable "resolveLookupCode": true. With this parameter nested attribute will de-dupe on canonical value i.e. Home and not on raw source values HOME/home



    ------------------------------
    Ashish Rawat
    Manager
    Fresh Gravity
    Bangalore
    ------------------------------

    Original Message


  • 3.  RE: Merge lowercase and uppercase values using matchFieldURIs

    Reltio Partner
    Posted 11-18-2022 10:33
    Hi Ashish,

    That will be my proposal as well if it has lookup values. Actual scenario will be merge Phone based on Only Phone number and Email based on Email Value.
    No issues for Phone numbers but for Email value, its tough.
    Merge abc@gmail.com with ABC@gmail.com, so that, we can eliminate duplicate values.


    ------------------------------
    Nagaraju
    PwC
    ------------------------------

    Original Message


  • 4.  RE: Merge lowercase and uppercase values using matchFieldURIs

    Reltio Employee
    Posted 11-18-2022 12:35
    Hi,
    You would be able to achieve that in a three step process - 

    Step 1 - If you are using a email cleanser, you can configure your cleanser to change case for all emails. The following will be required in your physical config - 
    {
    "cleanseFunction": "EmailCleanserFn",
    "options": {
    "casing": "lower"
    }
    }

    Step 2 - Make sure your survivorship is configured in a manner that cleanser value wins for email

    Step 3 - Configure matchFieldUri with matchOvOnly as true so that they match by case.
    https://docs.reltio.com/en/explore/get-going-with-apis-and-rocs-utilities/reltio-rest-apis/engage-apis/configuration-api/additional-examples-of-matchovonly

    In your case - 

    abc@gmail.com -> cleansed value (abc@gmail.com) -> OV value (abc@gmail.com)
    ABC@gmail.com -> cleansed value (abc@gmail.com) -> OV value (abc@gmail.com)

    Both OV values would be same resulting in matchFieldUris to merge


    ------------------------------
    Ranadip Das
    ------------------------------

    Original Message


  • 5.  RE: Merge lowercase and uppercase values using matchFieldURIs

    Founding Member
    Posted 11-21-2022 12:22
    Agreed with Ranadip, if the use case is to de-dupe on Email value itself.

    ------------------------------
    Ashish Rawat
    Manager
    Fresh Gravity
    Bangalore
    ------------------------------

    Original Message


  • 6.  RE: Merge lowercase and uppercase values using matchFieldURIs

    Reltio Partner
    Posted 11-22-2022 07:07
    Thank you Ashish & Ranadip
    It will help these tips to merge duplicate values for lookup and email attributes. I really appreciate your response.

    ------------------------------
    Nagaraju
    PwC
    ------------------------------

    Original Message