Unify and manage your data

Configure cleanse rules

Cleanse rule configuration details are part of tenant configuration and these rules can be applied to any entity type.

Configuration details for entity cleansing are available in the cleanseConfig section of the entity configuration.

HCP Entity with cleanseConfig

{
  "uri": "configuration/entityTypes/HCP",
  "cleanseConfig": {
    "mappings": [
      {
        "uri": "configuration/entityTypes/HCP/cleanseConfig/mappings/NameAttributeMappings",
        "inputMapping": [
          {
            "attribute": "configuration/entityTypes/HCP/attributes/FirstName",
            "mandatory": false,
            "allValues": false,
            "cleanseAttribute": "FirstName"
          },
          {
            "attribute": "configuration/entityTypes/HCP/attributes/MiddleName",
            "mandatory": false,
            "allValues": false,
            "cleanseAttribute": "MiddleName"
          },
          {
            "attribute": "configuration/entityTypes/HCP/attributes/LastName",
            "mandatory": false,
            "allValues": false,
            "cleanseAttribute": "LastName"
          }
        ],
        "outputMapping": [
          {
            "attribute": "configuration/entityTypes/HCP/attributes/Name",
            "cleanseAttribute": "Name",
            "mandatory": true,
            "allValues": false
          }
        ]
      }
    ],
    "infos": [
      {
        "uri": "configuration/entityTypes/HCP/cleanse/infos/PatternBasedFieldBuilder",
        "useInCleansing": true,
        "sequence": [
          {
            "chain": [
              {
                "cleanseFunction": "PatternBasedFieldBuilder",
                "resultingValuesSourceTypeUri": "configuration/sources/ReltioCleanser",
                "proceedOnSuccess": false,
                "proceedOnFailure": true,
                "filter": "exists(attributes.MiddleName) and exists(attributes.LastName)",
                "mapping": {
                  "inputMappingRef": "configuration/entityTypes/HCP/cleanseConfig/mappings/NameAttributeMappings/inputMapping",
                  "outputMappingRef": "configuration/entityTypes/HCP/cleanseConfig/mappings/NameAttributeMappings/outputMapping"
                },
                "params": {
                  "isForce": true,
                  "pattern": "{FirstName}-{MiddleName}-{LastName}"
                }
              },
              {
                "cleanseFunction": "PatternBasedFieldBuilder",
                "resultingValuesSourceTypeUri": "configuration/sources/ReltioCleanser",
                "proceedOnSuccess": false,
                "proceedOnFailure": true,
                "filter": "missing(attributes.MiddleName)",
                "mapping": {
                  "inputMappingRef": "configuration/entityTypes/HCP/cleanseConfig/mappings/NameAttributeMappings/inputMapping",
                  "outputMappingRef": "configuration/entityTypes/HCP/cleanseConfig/mappings/NameAttributeMappings/outputMapping"
                },
                "params": {
                  "isForce": true,
                  "pattern": "{FirstName}-{LastName}"
                }
              },
              {
                "cleanseFunction": "PatternBasedFieldBuilder",
                "resultingValuesSourceTypeUri": "configuration/sources/ReltioCleanser",
                "proceedOnSuccess": false,
                "proceedOnFailure": true,
                "filter": "contains(attributes.FirstName, 'Test')",
                "mapping": {
                  "inputMappingRef": "configuration/entityTypes/HCP/cleanseConfig/mappings/NameAttributeMappings/inputMapping",
                  "outputMappingRef": "configuration/entityTypes/HCP/cleanseConfig/mappings/NameAttributeMappings/outputMapping"
                },
                "params": {
                  "isForce": true,
                  "pattern": "{MiddleName}-{LastName}"
                }
              }
            ]
          }
        ]
      }
    ]
  },
  "attributes": [
    {
      "uri": "configuration/entityTypes/HCP/attributes/FirstName",
      "type": "String"
    },
    {
      "uri": "configuration/entityTypes/HCP/attributes/LastName",
      "type": "String"
    },
    {
      "uri": "configuration/entityTypes/HCP/attributes/MiddleName",
      "type": "String"
    },
    {
      "uri": "configuration/entityTypes/HCP/attributes/Name",
      "type": "String"
    },
    {
      "uri": "configuration/entityTypes/HCP/attributes/CleanseField",
      "type": "String"
    }
  ]
}