Reltio Connect

 View Only
  • 1.  Using "contains" for match rule

    Posted 08-15-2024 12:26

    Hello!

    In the Reltio search we are able to check if an attribute "Contains" a certain word to filter by it. 

    Are we able to do the same when creating a match rule? I don't see anything that would work the same. 

    Thanks!!



    ------------------------------
    ujwal upadhyay
    fultonbank
    ------------------------------


  • 2.  RE: Using "contains" for match rule

    Founding Member
    Posted 08-16-2024 14:54

    One of the approach, on top of my head is to use custom comparator, adjust the string matching percentage based on your use case



    ------------------------------
    Ashish Rawat
    Sr. Manager
    Fresh Gravity
    Bangalore
    ------------------------------



  • 3.  RE: Using "contains" for match rule

    Posted 08-20-2024 09:24

    Hello!

    Not sure if that'd be precise enough. We want to essentially ignore matches where "Test" is contained within an attribute. 



    ------------------------------
    ujwal upadhyay
    fultonbank
    ------------------------------



  • 4.  RE: Using "contains" for match rule

    Reltio Partner
    Posted 13 days ago

    Hi Ujwal,

    For your use case, Reltio offers two approaches - using a String Replacement Cleanser within the match rule or configuring a Custom Comparator Class.

    Option 1: String Replacement Cleanser

    You can apply the cleanser to your target attribute by preparing a text file with source and replacement strings. For example:

    ^(?!.*Test).*$=>

    In this case, the pattern on the left (the source string) excludes strings containing "Test", and the replacement string on the right is set to null. This setup ensures the ExactOrNull and ExactOrAllNull operators treat the attribute appropriately.

    Note: This regex is case-sensitive, so you'll need to include all case variations (e.g., test, TEST, etc.) in your file. The file should be uploaded to the Reltio cloud for your tenant with the assistance of Reltio Support.

    More information on how to setup the cleanser can be found here: String Replacement Cleanser

    Option 2: Custom Comparator Class

    Reltio offers the ability to establish a Custom Comparator Class within your L3 configuration. You can define a regex pattern using the "wordReplacements" parameter in your Custom Comparator:

    "wordReplacements": [
        {
           "pattern": "^(?!.*test).*$",
           "replacement": null
         }
    ]

    Note: There is a limit of 10 words in this configuration. If you need more, you can incorporate a RegexReplacementCleanser within your Custom Comparator class.

    Please check this documentation on more details on the configuration settings - Creating a Custom Comparator

    If you have any additional questions, or if you try one of the approaches and run into an issue, I would be happy to assist further.

    Regards,



    ------------------------------
    Lyubomira Alexandrova
    Ulpia Tech
    ------------------------------