Output standard columns used in tMelissaDataAddress - 7.3

Melissa Data address standardization

Version
7.3
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components
Last publication date
2024-02-21

The table below lists all the output standard columns in tMelissaDataAddress. These read-only columns are automatically added to the output schema.

Output column

Description

COMPANY_STANDARDIZED

This column returns a standardized company name.

ADDRESSLINE1_STANDARDIZED

This column returns the first line of the address.

ADDRESSLINE2_STANDARDIZED

This column returns the second line of the address.

CITY_STANDARDIZED

This column returns a standardized city name.

STATE_STANDARDIZED

This column returns a two-letter abbreviation for the state name.

COUNTRY_STANDARDIZED

This column returns a two-letter abbreviation for the country name.

RESULTS_CODE

This column returns verification codes to indicate data quality, statuses and errors. These codes are written in comma-delimited lists. Each code consists of two letters followed by two numbers.

For example, the AC02 code means that the state name is corrected based on the combination of city name and ZIP code.

For a complete list of the result codes visit http://www.melissadata.com/.