Skip to main content Skip to complementary content

Saving and executing the Job

Procedure

Save your Job and press F6 to execute it.

Results

The tMelissaDataAddress reads the input address rows, corrects and formats the addresses and gives the result in a kind of "standardized" address output rows.

In addition to verifying and standardizing an address, tMelissaDataAddress will also match street names against a ZIP code, match geographic data to ZIP code and city information and finally parse street addresses and return all these results via different output columns. This example shows only some of the output columns written by the tMelissaDataAddress component:
  • GetAddressKey returns the Address Key.
  • GetCountyName returns the county names.
  • GetTimeZone returns the time zone.
  • GetLongitude returns the longitude data.
  • GetLatitude returns the latitude data.
  • GeoCodeResult returns the GeoCode result codes.
  • The output standard columns return the standard company name, up to two street address lines, the standard city name, two-letter abbreviation for the state name, the postal ZIP code, and two-letter abbreviation for the country name.

  • The RESULTS_CODE output column returns verification codes for each of the processed address rows. These codes are written in comma-delimited lists. Each code consists of two letters followed by two numbers. These codes indicate different statuses and errors. For example, the AC02 code means that the state name is corrected based on the combination of city name and ZIP code, and the AS01 code means that the street address is valid and deliverable.

For a complete list of the result codes and for further information about all the output columns,visit http://www.melissadata.com/.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here