Accelerate the Value of Data

Address Cleanse Options

You can enable server options for address cleansing.

You can enable the server options in one of the following ways:
  • In the Physical Configuration - Contact the Support Team to enable a server option at the physical configuration level.
  • In the L3 Configuration - See Configuring the Server Options to configure a server option in your L3.
Note: Your L3 configuration overrides the physical configuration.

After enabling the server options, re-cleanse the tenant to ensure that the enabled server options are applied and affect the existing location. Also, the process of cleansing can have an effect on the matching rate, because the standardized locations that were not matching, can match and eventually merge into one.

Table 1. Address Cleanse Options
Options Description
AddressLineSeparator Used to specify the string that separates the Output Address lines within the Output Address field.
CasingIgnoreFields Used to specify the fields that must not be cased. The default value is ID,PostalCode,PostalCodePrimary,PostalCodeSecondary,ISO3166-2,ISO3166-3,PostBox,PostBoxNumber,PostBoxType,_L,Latitude,Longitude,GeoAccuracy,GeoDistance,AVC
CombinedVerifyMethods When the CombinedVerifyMethods option is enabled, the flexible spelling correction option gets applied during the verification process. This server option is enabled by default. The possible values are Yes (default) and No.

For more information about this option, see Understanding the CombinedVerifyMethod Option.

DataDirectory Used to specify the directory in which the Global Knowledge Repository must be found (other than the directory of the loqate.ini configuration file specified during the lqtServer::init call).
DefaultCountry Used to specify the ISO 3166-1 alpha-3 code. This must be used if no identifiable country is found in the input record.
DuplicateHandlingMask This option is enabled to remove valid duplicate components in the input address and enhance the address cleansing accuracy. This option can be enabled to remove duplicates across all levels of an input address. Depending on the level at which this option is enabled in the L3 configuration, the duplicates present in the address can be removed either from the same line or across all levels of input. For more information about this option, see DuplicateHandlingMask option.
EnhancedCountryTool Allows you to enable the Automatic Country Identification.
  • To enable the option, set the value of the option to ON or True.
  • To disable the option set the value to OFF or False. The default value is False.
FormatFields A list of default field formats for those fields that can be derived from a combination of other fields. This can be overridden on a per-country basis and must only be changed if requested by the Support Team.
IgnoreUnmatched Allows unmatched input data within the address lines to be ignored during a search process. Hence, allowing the search to proceed by matching only the partial input data.

Consider the address, 4 Slapp Hill Rd Hardwick VT 05843 USA. If the IgnoreUnmatched option is enabled and is equal to 1, then the address is not converted to 4 Baker Hill Rd Hardwick VT 05843 USA.

By default, the IgnoreUnmatched option is not enabled. To enable this option as per your business requirements, contact Reltio’s Customer Support Team.
LogFileName Used to specify a file name to debug output. Must be specified before the lqtServer::init call.
MinimumVerificationLevel Used to specify the minimum verification level that a record must reach in order to avoid reversion. For more information about this option, see MinimumVerificationLevel option.
NativeAddressLineReverse Used to specify whether to reverse the order of the Input Address lines when processing non-Latin data. Usually, this is set on a per-country basis automatically, but can be overridden by setting the server option as appropriate.
  • When set to False, any input Address Lines are linked together in normal order (for example, Address1 + Address2 + Address3).
  • When set to True, any input Address Lines are linked together in reverse order (for example, Address3 + Address2 + Address1).
OutputCasing Used to specify the letter case to be used in Output fields. Valid options are Upper, Title, or Lower. The default value is Title.
OutputScript Used to specify the ISO 15924 Code, in which the output must be encoded, if possible. Alternatively, Native must be specified to choose the correct country specific script value.
OutputSortType Used to specify the order in which the Search output results must be sorted.
  • To sort in alphabetical order use Alphabetical.
  • Alternatively, specify Address Verification Code (AVC) to sort from the highest verification level to the lowest verification level. For more information about AVC, see Understanding Address Verification Code.
  • The option can also be set to Similarity. This gives an indication of the percentage of the Input characters that have been matched with the Output.
  • The default value is AVC.
PreferPrimaryValidAlias Used to standardize and verify address to a single record. For example, let us consider the two address records below:
  • 276 Pondella Road, N Ft Myers, FL, USA
  • 276 Pondella Rd, North Fort Myers, FL, USA

If PreferPrimaryValidAlias is enabled, the two addresses are standardized and verified to a single record as, 276 Pondella Rd, North Fort Myers, FL, USA. For more information about this option, see Address Standardization.

SuppressAddressFields Used to specify the comma-separated list of fields that must be suppressed from the Address field Output.
SuppressFields Used to specify the comma-separated list of fields that must be suppressed from the Output.
SuppressUnmatched If this option is set to TRUE or ON, then unverified fields do not appear as Output in the Address fields (Address, Address1, Address2, and so on). The default option is FALSE or OFF.
StrictReferenceMatch Helps to output results that are identical to what is found within the reference data. For example, if an Input Address has a premise of 08, but the reference data contains 8, then the Premise is verified with a Premise Number output of 08. Turning on StrictReferenceMatch gives the output as 8. The default value is No.
TransliterationIgnoreFields Used to specify the fields that must not be transliterated. The default value is ID,ISO3166-2,ISO3166-3,_L,Latitude,Longitude,GeoAccuracy,GeoDistance,AVC.