Listware for Excel:Global:Input Columns

From Melissa Data Wiki
Jump to navigation Jump to search

← Listware for Excel Reference

Global Check and Verify Navigation
← Listware for Excel Overview
Overview
Tutorial
Steps
Processing Range
Cleansing Operations
Input Columns
Output Columns
Reporting
Review Settings
Processing
Review Results
Result Codes



Specify the input columns you want to process by selecting them in the drop-down menus.

The following input columns are available:


Address

Organization
Specify the column that contains company and/or organization names.
Address Line 1 - Address Line 8
Specify the column(s) that contain address information.
Dbl-Dep Locality
Double-Dependent Locality. An area or village (e.g. UK) within a Dependent Locality required to identify an address.
Dep Locality
Dependent Locality. A district, area, or neighborhood (e.g. Turkey) within a Locality required to identify an address.
Locality
A city (e.g. US), town, or municipality (e.g. Canada) that is the most common population center element within an Administrative Area.
Sub-Admin Area
A county (e.g. US) or region larger than the Locality but smaller than the Administrative Area.
Admin Area
A state (e.g. US), province (e.g. Canada) or canton (e.g. Switzerland) contained within a Country.
Postal Code
The postal code or ZIP code (e.g. US) for the input address.
Sub-Natl Area
Sub-National Area. Not commonly used. An arbitrary region smaller than a Country but larger than an Administrative Area.
Country
Country name or code of the input address.