1 Reply Latest reply: Feb 17, 2012 7:23 AM by 670129 RSS

    ADDRESS CLEANING(US) USING ODQ

    606607
      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
          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