This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This 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:
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_Results field 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 firstname.lastname@example.org you’d like your creative tool uses to be featured in the Tool Mastery Series.
Stay tuned with our latest posts every Tool Tuesday by following Alteryx on Twitter! If you want to master all the Designer tools, consider subscribing for email notifications.