Location Data Knowledge Base

Data methodologies, and Release schedules.

Tool Mastery | CASS

Alteryx Alumni (Retired)

1.pngThis article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the CASS Tool on our way to mastering the Alteryx Designer:

Please note that usage of the CASS Tool requires an Alteryx Designer with Data license. Data products subscribers can download it here.

You know what really stinks? Working with addresses that aren’t standardized or verified. Whether human-input, or one of the many address formatting standards in the U.S., being stuck with an address you can’t either (1) identify or (2) ensure it exists can be a real pain in the… well…

CASS is here to help! The Coding Accuracy Support System provided by the United States Postal Service (USPS) is used to evaluate the accuracy of addresses (as compared to their records), and is the basis of the CASS Tool. Using it can improve your address and spatial workflows by…

  • Allowing you to inspect each of your addresses for accuracy/existence:


The CASS_Resultsfield specifies the different types of recognition; AS01 is a verified address.

  • Cleaning address records:


  • Obtaining Zip 9 (Zip +4) and other more granular address information:


Attached is a v10.6 workflow with each of the use cases mentioned above. If you want to learn more about the CASS Tool, check it out on our Engine Works Blog! Just having trouble with errors? Try our troubleshooting checklist(available to data products subscribers).

By now, you should have expert-level proficiency with the CASS Tool! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know atcommunity@alteryx.comif you’d like your creative tool uses to be featured in the Tool Mastery Series.

Stay tuned with our latest posts every Tool Tuesdayby following Alteryxon Twitter! If you want to master all the Designer tools, consider subscribingfor email notifications.

7 - Meteor

Will Alteryx include NCOA address module one day...?? Really need it!!