Verify Address

The Verify Address transform parses, matches, and formats address data against reference postal data. A confidence level is assigned to each verified record.

Validation includes cleansing, supplementing, and standardizing data.

  • Cleansing includes tasks such as fixing a typo in a street name or removing non-existent street or company names.
  • Supplementation adds missing components, such as a postal code.
  • Standardization encompasses address parsing and formatting, such as placing the house number before or after a street name and normalization of abbreviations.

You may optionally retain the original data. The transformation adds a Confidence column that specifies the confidence level (0–100) that each record contains a valid address. A confidence level at some level less than 100 can be used to flag records for manual review.

Step name
Defines the name for a step. Provide a meaningful name so that anyone who edits transformation steps in a pipeline will be able to identify the purpose of a step.
Preserve input fields
Select this check box to retain input field columns. The preserved column names are prefixed by input_. Mapped output columns set to none add empty columns with the input_ prefix.
Preview
Click to preview the address verification. This displays original data columns in the Original section, followed by preview columns with verified and standardized field values in the Transformational Preview section. Any portion that has no match in the reference data is removed from the Transformational Preview columns. For example, "123 Main St" shows as "ST" if a city has street addresses but no "Main St". The added Confidence column shows the confidence level (0–100) for each verified record.
Add another address
Click this button to add an additional set of address mappings. Address mappings map dataset fields to input fields. There is initially one set of mappings, titled Address_set_1. If data includes more than one address—such as shipping and billing addresses, or a home and business addresses—you can click this button to add additional mappings. Additional address sets increment the index (Address_set_2, Address_set_3, and so forth)
Address_set_1, Address_set_2, … .
One or more address sets map output fields to input fields. The Input fields column specifies standard address field types. The Mapped output column maps dataset fields to the standard address field types. To map a dataset field, click the column heading in a Mapped output box that corresponds to a field name in the Input fields column. Choose none when there is not dataset field that corresponds to an input field. When there is more than one mapping, configure each mapping.
An Address_set table contains the following standard address field types. Address formats and values represented by each field type depend on the country (such as "states" divided into "counties" in the United States or "regions" divided into "districts" or "counties" in England).
  • FirmName Specifies an organization name, place, or building. Examples:
    • PRIME MINISTER& FIRST LORD OF THE TREASURY
    • ARAMARK Ltd.
    • UNITED NATIONS HEADQUARTERS
  • AddressLine1 Street portion of the address, including the directional and street suffix, formatted to the country's standard. Examples:
    • 10 DOWNING STREET
    • 630 W 168TH ST
  • AddressLine2 Location portion of the address, formatted to the country's standard. Examples:
    • LONDON SW1A 2AA
    • NEW YORK, NY 10032-3725
  • City Specifies a city or town name. Examples:
    • London
    • New York
  • CitySubdivision Specifies a city subdivision or locality. Typically a division such as neighborhood, hamlet, or borough. Examples:
    • Bromley
    • Brooklyn
  • StateProvince The first-level administrative division in a country. Typically a division such as state, province, department, region, or territory. Examples:
    • New York
    • West Midlands
  • StateProvinceSubdivision The second-level administrative division in a country. Typically a division such as county, municipality, parish, prefecture, or district. Examples:
    • Nassau County
    • Coventry
  • PostalCode The postal code used by a country. Examples:
    • 10032-3725
    • SW1A 2AA
  • Country The country name. Examples:
    • United States or USA
    • France
Save
Click this button to close settings and save changes to the transformation settings.
Preview
Click this button to preview the results of the transformation settings.
Cancel
Click this button to close settings for this transformations without saving any changes.