Reltio Connect

 View Only
  • 1.  Merge lowercase and uppercase values using matchFieldURIs

    Reltio Partner
    Posted 12 days ago
    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 days ago

    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
    ------------------------------



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

    Reltio Partner
    Posted 11 days ago
    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
    ------------------------------



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

    Reltio Employee
    Posted 11 days ago
    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
    ------------------------------



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

    Founding Member
    Posted 8 days ago
    Agreed with Ranadip, if the use case is to de-dupe on Email value itself.

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



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

    Reltio Partner
    Posted 7 days ago
    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
    ------------------------------