âShow Table of Contents
The Parse Address tool breaks down a street address into its component parts, such as street number, directional (S, NW, and so on), street name, and suffix (ST, RD, BLVD).
The tool can also parse Last Line data (city, state, and ZIP Code) into the separate parts. This is handy if your address data comes to you as lines of plain text instead of discrete fields.
The CASS Address Parse Tool uses the CASS library, a separate data install that is only available with the Alteryx Spatial offering. It requires a special license to run.
Any address field can be passed through this tool. While the CASS library installation is required, you do not have to run it through the CASS Tool to parse the address data.
Specify the Address field to parse using the dropdown list.
Specify the Last Line field to parse using the dropdown list. This is an Optional field.
Check the Parse Canadian Addresses checkbox only if your input contains Canadian Addresses.
Choose to output a single parsed candidate or to output all parsed candidates.
Output Single Parse Candidate: Each record gets parsed and a single record is returned. This option typically returns the best parse candidate, but may not when there are multiple candidates.
Output All Parse Candidates: Each record gets parsed and every possible parse candidate gets returned, meaning a record may have multiple ways of being parsed and each method becomes its own record on output.
Select the Output Fields to return using the checkbox to the left of the field name. The All, US Default, CA Default, and Clear Button should help with making multiple selections. Output fields are defined below:
CASSParse_Garbage: Any garbage characters left over after the address has been parsed. The returned value is a maximum 50-character string. Common items found in this field are community center names, names of individuals, additional delivery instructions and so on.
Example: "West Wing" or "Deliver on back porch."
The CASS Address Parse tool does NOT do any address checking. Therefore if the input address does not contain a recognizable four-digit ZIP add-on, there will be no value returned in this field.
CASSParse_PostDirection: The geographic directional that follows the street name. The value is returned as a maximum 2-character string. Directions such as "North" will be changed to "N" in the outputted field.
Example: For the address 100 N Main St; The CASSParse_PreDirection field will hold the N. Directions such as "North" will be changed to "N" in the outputted field.
Typical Suffix values include: "ST;" "RD;" "AVE;" "BLVD;" "CIR;" and "PL."
Typical Suite Name values are: âr;#;â âr;APT;â âr;BLDG;â âr;BOX;â âr;BSMT;â âr;DEPT;â âr;FL;â âr;FRNT;â âr;HNGR;â âr;LBBY;â âr;LOT;â âr;LOWR;â âr;OFC;â âr;PHâ (Penthouse); âr;PIER;â âr;REAR;â âr;RM;â âr;SIDE;â âr;SLIP;â âr;SPC;â âr;STE;â âr;STOP;â âr;TRLR;â âr;UNIT;â âr;UPPR.â
CASSParse_CA_DeliveryInstallation: Canada Addresses only - The Delivery Installation information is returned. The delivery installation is the post office facility responsible for delivering to the current address. It is often used for rural addresses or when multiple post offices service the same municipality.
CASSParse_CA_LockBox: Canada Addresses only - The lock box information is returned. A lock box is the Canadian equivalent of a Post Office Box in the US. The two terms are used interchangeably in Canada.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, Guzzler