Reltio Connect

 View Only

  • 1.  Cleanser to remove a string

    Posted 07-18-2024 22:09
    Need to remove a string "test" from the firstname. Since Scrub is removing the characters,  tried PatternBasedFieldCleanser to remove the entire string .
    But its not working as expected. 
    FirstName : SwethaTest
    Expected output :  Swetha
    "infos": [
    {
            "uri": "configuration/entityTypes/Contact/cleanse/infos/PatternBasedFieldBuilder",
            "useInCleansing": true,
            "sequence": [
              {
                "chain": [
                  {
                    "cleanseFunction": "PatternBasedFieldBuilder",
                    "resultingValuesSourceTypeUri": "configuration/sources/ReltioCleanser",
                    "proceedOnSuccess": true,
                    "proceedOnFailure": true,
                    "mapping": {
                      "inputMapping": [
                        {
                          "attribute": "configuration/entityTypes/Contact/attributes/FirstName",
                          "mandatory": false,
                          "allValues": false,
                          "cleanseAttribute": "FirstName"
                        }
                      ],
                      "outputMapping": [
                        {
                          "attribute": "configuration/entityTypes/Contact/attributes/FirstName",
                          "mandatory": true,
                          "allValues": false,
                          "cleanseAttribute": "OutputText"
                        }
                      ]
                    },
                    "params": {
                      "isForce": true,
                      "pattern": "test"
                    }
                  }
                ]
              }
            ]
          }


    ------------------------------
    Swetha Soundarapandian
    Mastech Infotrellis
    SALEM
    ------------------------------


  • 2.  RE: Cleanser to remove a string

    Reltio Employee
    Posted 07-22-2024 10:51

    Swetha,

    Using the Pattern Cleanser you can only create the pattern and not replace the string. You can find the examples here: 

    https://docs.reltio.com/en/model/cleanse-data/cleanse-and-standardize-data-overview/out-of-the-box-cleanse-functions/pattern-based-cleanser


    However, if SwethaTest needs to be replaced with Swetha then you can leverage "S3 File Cleanser", you can find the details here: 

    https://docs.reltio.com/en/model/cleanse-data/cleanse-and-standardize-data-overview/out-of-the-box-cleanse-functions/s3-file-cleanser

    The cleanser file can have the below pattern, this file must reside in an S3 location and the S3 details and path should be specified in the Physical Configuration. 

    SwethaTest=Swetha



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

    Original Message


Related Content