August 15, 2023

Output standard columns used in tMelissaDataAddress – Docs for ESB 6.x

Output standard columns used in tMelissaDataAddress

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


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x