Address Standardization

Highlighted
Six Stars

Address Standardization

Hi 

 

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

thanks in advance.

 

Regards

Krishu

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.
Six 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)

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read