This discussion is archived
1 Reply Latest reply: Feb 17, 2012 5:23 AM by 670129 RSS

ADDRESS CLEANING(US) USING ODQ

606607 Journeyer
Currently Being Moderated
Hi All,

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.

Thanks,
Rathish
  • 1. Re: ADDRESS CLEANING(US) USING ODQ
    670129 Newbie
    Currently Being Moderated
    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.

    Steve Sarsfield

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points