topic Re: Address Standardization in Data Quality

Address Standardization

krishu — Sat, 08 Jul 2017 17:49:08 GMT

Please can anyone help on how to do address standardization for India address.

thanks in advance.

Regards

Krishu

Re: Address Standardization

Anonymous — Mon, 10 Jul 2017 03:54:04 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Have you checked DQ component tMelissaDataAddress which verifies that an address is a properly formatted address and corrects any formatting or spelling errors in each row.

Best regards

Sabrina

Re: Address Standardization

Anonymous — Wed, 12 Jul 2017 03:48:59 GMT

Hi Xdshi

Is this component only for commerial DQ or can it be used for Open Studio?

Re: Address Standardization

Anonymous — Wed, 12 Jul 2017 04:49:20 GMT

Hello,

Actually, talend open studio for data quality doesn't have job designer and ELT&ETL support.

Please refer to talend official website page about product matrix:

http://www.talend.com/products/data-quality/?_ga=2.45437666.75713403.1499652479-1289787410.1496918705

Best regards

Sabrina

Re: Address Standardization

krishu — Wed, 12 Jul 2017 07:46:13 GMT

My input is:

ADDRESS

Flat No.23/5A,5th Main,Lalbhag marg,Pune,420165

Output should be:

House No	Street	Locality	City	Zip
Flat No.23/5A	5th Main	Lalbhag marg	Pune	420165

Regards

Krishu