Reltio Connect

 View Only

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

    Posted 29 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 23 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 22 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 22 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 22 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