Hello,
Our Requirement:
We have two Address tables with similar columns.
The problem arises when we are matching these addresses as the
Good address from one file is :
1508 GARDINGER WAY , ARLINGTON HEIGHTS, IL, 60004
The Other source has Bad addresses like:
1508 GARDINGER WY, ARLINGTON HTS, IL , 60005
Would love to know whether CASS tool would solve this issue (any test output data from CASS tool, details on pricing for the license is appreciated) or if there is any other solution available.
Hi @SuyashRoy , it won't "solve" the problem, but here is what it will do:
(a) It will standardize (per USPS standards) whatever you enter. For example, it will change Drive to Dr, or Suite to STE, etc. It will do this without regard to whether or not the address is found in the CASS system
(b) Once standardized, it will look in the CASS system and give you back a code telling you if it's found or not (actually, there is quite a good bit of detail behind the codes. Check out http://wiki.melissadata.com/index.php?title=Result_Codes and https://help.alteryx.com/10.0/index.htm... .
I did just enter both of your addresses you provided, but both come up as not found:
Hi @mbarone, Thank you for the solution.
We just wanted to inquire whether it is possible for the CASS tool to give a standardized output for both the addresses, for eg:
convert the bad address 1508 GARDINGER WY, ARLINGTON HTS, IL , 60005 to 1508 GARDINGER WAY , ARLINGTON HEIGHTS, IL, 60005 basically converting WY to WAY and HTS to HEIGHTS like it converts Drive to Dr, or Suite to STE. So if its possible for CASS to give a standardized output in this regard.
We also wanted to inquire if there is an other solution to this other than the CASS tool.
From the above, it appears that both WY and WAY, and both HEIGHTS and HTS are acceptable by the USPS since each one was output as the CASS address. The code AE02 means that they can't find the address. I'm not sure if there are other solutions.