Difference between revisions of "Listware for Excel:Global:Input Columns"

From Melissa Data Wiki
Jump to navigation Jump to search
(Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font...")
 
Line 2: Line 2:


{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Global Navigation'''
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Global Check and Verify Navigation'''
|-  
|-  
| style="padding-right:220px;"|
| style="padding-right:220px;"|
|-
|style="border-bottom:1px solid #aaaaaa;"|[[Listware for Excel:Check and Verify|← Check and Verify]]
|-
|-
|[[Listware for Excel:Global|Overview]]
|[[Listware for Excel:Global|Overview]]

Revision as of 21:43, 15 September 2014

← Listware for Excel Reference

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



LWE Global InputColumns.png

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.