Reltio Connect

 View Only

  • 1.  Match rule : helper operator to check for null values

    Posted 14 days ago

    I have a requirement to create a match rule as below.

           #1. Exact match on Attribute 1, Attribute 2 and Attribute 3

           #2. Exclude profiles from matching whose Attribute 4 value is nulls

    Is there a helper operator to configure #2 ? 



    ------------------------------
    Sumeet Vaidya
    ------------------------------


  • 2.  RE: Match rule : helper operator to check for null values

    Reltio Employee
    Posted 7 days ago

    Hi Sumeet, 

    We can implement such a match rule using the following approach: 

    1. Define a cleanseAdaptor using "cleanseAdapter": "com.reltio.cleanse.impl.RegexpReplaceCleanser"
    2. use the directory to identify Regular Expression for Matching Empty or Whitespace Only and convert it to a unique value eg: "NOT_TO_MATCH"
    3. Use the notEquals operator to exclude them from matching where attribute 4 = NOT_TO_MATCH  


    ------------------------------
    Girish Kalburgi
    Reltio
    NC
    ------------------------------

    Original Message


  • 3.  RE: Match rule : helper operator to check for null values

    Posted 7 days ago

    Thanks Girish.

    For point #2 in your response, what does 'use a directory' mean ? Is it an external file that has the RegEx rule and the replacement value ?

    Thanks,

    Sumeet



    ------------------------------
    Sumeet Vaidya
    ------------------------------

    Original Message


  • 4.  RE: Match rule : helper operator to check for null values

    Reltio Employee
    Posted 7 days ago
    Yes, it would be a file in the S3 bucket and you can find an example here. The challenge here will be to identify the regular expression to identify null (empty string). 

    "cleanse": [
        {
          "cleanseAdapter": "com.reltio.cleanse.impl.RegexpReplaceCleanser",
          "cleanseAdapterParams": {
            "dictionary": "https://s3.amazonaws.com/test.api.tmp.data/myStringMods.txt",
            "keepOriginalValue": "false"
          },
          "mappings": [
            {
              "attribute": "configuration/entityTypes/HCO/attributes/Name",
              "cleanseAttribute": "configuration/entityTypes/HCO/attributes/Name"
            }
          ]
        }
      ]




    Original Message


  • 5.  RE: Match rule : helper operator to check for null values

    Posted 7 days ago

    Thanks Girish.

    Does the Cleanse Adaptor have the option to specify an inline Regx expression instead of using an external file ? 



    ------------------------------
    Sumeet Vaidya
    ------------------------------

    Original Message


Related Content