Accelerate the Value of Data

Configuring Cleanse to use Raw Value when lookup fails

Learn how to configure the cleanser raw lookup values

When you configure an attribute, you can provide an RDM look up code to be presented as input to cleanser. Sometimes, this RDM look up code is not available. This situation triggers the cleanser to use a null or default value, in case of the attribute Country, as input on post entity call or re-cleanse of the entity.

For example, when you perform a post entity call for the State attribute California that has an RDM look up code of CA, then the value CA is used as input to the cleanser. However, if the State attribute Texas does not have an RDM look up code available, the input to cleanser will be null.

Post entity raw look up valueResolved RDM look up codeInput to cleanser
CaliforniaCACA
Texasnull

There is an optional parameter that allows raw look up values to be used as input to cleanser instead of null when RDM lookup fails.

To set the optional parameter flag useRawValueAsDefaultForCleanse to true, use the Self-Service Tenant Configuration within the optionalParameters of the physical configuration. For more information, see topics Cleanse configurations and View and edit tenant configuration.

The table below represents the post entity call behavior when useRawValueAsDefaultForCleanse is enabled or set to true, the State attribute has a look up configured and the parameter resolveLookupCode is true. For more information on the parameter resolveLookupCode, see topic Resolve attribute or tenant lookups.

Post entity Input for state attributeResolved RDM look up codeInput to cleanse
CaliforniaCACA
TexasTexas