Using the Data Quality Accelerator for Crisis Response

Back Next

Address Data Cleansing Rules

Use the address data cleansing rules to parse, standardize, and validate address data. Find the address data cleansing rules in the following repository location:

[Project_Name]\Rules\Address_Data_Cleansing

The following table describes the address data cleansing rules:

Name	Description
rule_Country_Identification	Identifies a country identifier in the column(s) that the rule specifies.
rule_Country_Name_Standardization	Standardizes country names. The rule returns a country name, a two-character ISO country code, and a three-character ISO country code.
rule_Geocoordinate_In_Polygon	Verifies the presence of geocoordinate points within an area that three or more geocoordinate points define.
rule_Global_Address_Validation_Hybrid	Validates the deliverability of address records from multiple countries. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Hybrid input fields on the Address Validator transformation.
rule_USA_County_Validation	Validates United States county names. The rule compares input data against county names in all states. The rule returns "Valid" or "Invalid."
rule_USA_State_Validation	Validates United States state names. The rule returns "Valid" or "Invalid."
rule_USA_ZIPCode_Validation	Validates five-digit United States ZIP Codes. The rule returns "Valid" or "Invalid."

Rename Saved Search

Table of Contents

Using the Data Quality Accelerator for Crisis Response

Using the Data Quality Accelerator for Crisis Response

Address Data Cleansing Rules

Address Data Cleansing Rules