Address standardization
Learn about standardizing addresses to a particular format of address record.
Reltio’s cleanse functionality provides a range of configuration options to control the degree in which addresses are standardized, verified, and validated to a particular format of an address record.
For example, consider the two address records below:
- 276 Pondella Road, N Ft Myers, FL, USA
- 276 Pondella Rd, North Fort Myers, FL, USA
The desired effect is to have the two above addresses standardized and verified to a
single record as, 276 Pondella Rd, North Fort Myers, FL, USA.
This functionality is achieved by setting to "Yes" the Reltio Cleanse configuration option PreferPrimaryValidAlias.
When PreferPrimaryValidAlias is not enabled, the City N Ft Myers is returned as verified with no change.
When PreferPrimaryValidAlias is enabled, the City N Ft Myers is verified with Alias change, and first valid alias found, North Fort Myers is returned.
Hence, if PreferPrimaryValidAlias is enabled, the two addresses below
are standardized and eventually merged.
- 276 Pondella Road, N Ft Myers, FL , USA
- 276 Pondella Rd, North Fort Myers,FL, USA
Enable the PreferPrimaryValidAlias option
The PreferPrimaryValidAlias configuration option can be enabled using server options (opts) at the L3 configuration, set to "Yes". Following are some points on how this option works:
- Addresses are standardized for AddressLine1, AddressLine2, and locality.
PreferPrimaryValidAliasis optional for tenants that are CASS enabled. By default, CASS standardizes addresses.- The Recleanse JOB/TASK must be executed for the existing
customers after the
PreferPrimaryValidAliasserver option is enabled. - Merges or potential matches can be observed for entities during the recleanse operation. Recleansing the address using this option may change the data and result in possible new merges. This behavior is expected but should be carefully planned for.
PreferPrimaryValidAlias option is not enabled by default, set to "No" by omission.
Hence, as an immediate impact, location is cleansed as per the existing L3 config.
To enable the PreferPrimaryValidAlias option in the tenant configuration, contact Reltio’s Customer Support Team. Note that the L3 configuration always overrides the tenant configuration.