Five Stars

Address Standardization

Hi 

 

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

thanks in advance.

 

Regards

Krishu

  • Data Quality
4 REPLIES
Moderator

Re: Address Standardization

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Address Standardization

Hi Xdshi

 

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

Moderator

Re: Address Standardization

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.149691870...

Best regards

Sabrina1.png

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Address Standardization

My input is:

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

 

Output should be:

House NoStreetLocalityCityZip
Flat No.23/5A5th MainLalbhag margPune420165

 

Regards

Krishu

Tags (1)