Address Parse

Parent Previous Next


Address Parse Transform


The "Address Parse Transform" is used to parse unformatted address data and transforms it into USPS standardized address data.



Input Options

 Single column contains all address data - Use this option when all of the address data from your source is contained in a single column.

 Address data is spread across multiple columns - Use this option when the address data from your source is not contained in a single column. You will choose which column from your source contains the address element needed by the transform.


The address data input tab is used to map the source input columns to the appropriate address elements in the address parse transform. Your source does not have to contain a one to one relationship to the address elements in the address parse. You can map a single column from your source to multiple address elements in the transform. For example:


AddressLine1 column:

Address

AddressLine2 column:

Address

City column:

CityStateZip

State column:

CityStateZip

PostalCode column:

CityStateZip


Address Quality


The address parse assigns a level of quality to two sections of the address:


1.   Address Line 1 and Address Line 2

2.   City, State, and Zip


There are three levels of quality that can be assigned to the two sections of an address:


 High

o  Address Line 1 and Address Line 2 - The address is technically complete

o  City, State, Zip - These fields are technically correct

  Medium

o  Address Line 1 and Address Line 2 - The address is complete but missing a part of the address like apartment number or street suffix

  Low

o  For Address Line 1 and Address Line 2 - The address is not verifiable

o  For City, State, Zip - Either the City, State, or Zip Code is missing


When the address parse runs it will parse out the data and assign the level of quality based on whether it can find a valid address and a valid city, state, and zip according to the rules above. You can either include all of the address as part of the output from the transform or you can choose "Include only high quality parsed addresses". Selecting this means that the output named "Parsed Address Output" will contain addresses that are considered high quality. If you choose this option you must also make a selection from the "What should happen to non-parseable (low quality) addresses?" drop down menu.


 Ignore Failures - This option will skip the addresses marked as low quality

 Redirect Errors to Error Output - This option will redirect the rows to the error output

 Fail Component - This option will fail the component when the first invalid address is found

 Redirect Errors to Non-Parseable Output - This option will redirect the rows to the "Non-Parsed Address Output"


Parsed Output


The parsed output tab defines how you want the parsed address data outputted from the transform. The default is that there will be new columns for each address elements and quality elements as part of the "Parsed Address Output".


Output Columns


 Address Data Column  - The address data column defines the data that will be outputted from the transform

 Action Column  - The action column defines whether the output will contain a new column or the data in an existing column

o  Add New Column - This will tell the transform to add a new column to the output. The columns to the right of the action column are used to define the properties of the output column. The data for the respective address data column will be contained in the output column defined in the "Output Column Name" column.

o  Replace Column - This will tell the transform to replace the data in a source column instead of using an output column. You will need to select the name of the source column to replace in the "Output Column Name" column. If this option is selected, all of the columns to the right of "Output Column Name" are now read-only.

 Output Column Name - Defines either the name of the output column if "Add New Column" is selected in the "Action" column or the name of the source column to replace if "Replace Column" is selected.

 Output Data Type  - Choose the output data type

 Output Length  - Define the length of the column

 Code Page - Change the code page

 Output Case Formatting - Define how the output is determined

o  Proper Case - This will transform all of the data in the parse address to proper case (First letter of every word is upper case)

o  Upper Case - This will transform all of the data in the parse address to upper case

o  No Case Formatting - This will not transform the case of the data