Can any body help me to start with cleaning Address (US) using ODQ.
IS there any specific documents for ADDRESS CLEANING which gives more information about the process flows such as
Transformer, Customer Data Parser, Sort for Postal Matcher, Postal Matcher, Window Key Generator,Sort for Linking, Relationship Linker, Commonizer, and Data Reconstructor.
My requirement is some thing like this.
I have one Column for ADDRESS. in that the data is not in a standard format.
i need to clean tha data and make it perfect
for eg :
if Address is like 501-306,701-706,801-806 Leave as it is
164 CLIFTON AVENUE APT #2 should be cleaned as 164 CLIFTON AVENUE
2-30 LAGOON WAY, units a, b should be cleaned as 2-30 LAGOON WAY
Is this possible using ODQ ?
Waiting for your valuable reply.
This is best accomplished in the data reconstructor. The customer data parser willl break apart the house number, street name and all the addition address information into their own buckets. Then use the data reconstructor to rebuild the address, taking only the parts you need.
Keep in mind that the additional information is crucial for correct delivery and postal discounts. You may want to think about the long-term uses of this data before you strip that information out.