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...")
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
[[Listware for Excel:Reference|← Listware for Excel Reference]]
{{LWEGlobalNav
 
|StepsCollapse=
{| 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="padding-right:220px;"|
|-
|[[Listware for Excel:Global|Overview]]
|-
|[[Listware for Excel:Global Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:Global:Processing Range|Processing Range]]
|-
|[[Listware for Excel:Global:Cleansing Operations|Cleansing Operations]]
|-
|[[Listware for Excel:Global:Input Columns|Input Columns]]
|-
|[[Listware for Excel:Global:Output Columns|Output Columns]]
|-
|[[Listware for Excel:Global:Reporting|Reporting]]
|-
|[[Listware for Excel:Global:Review Settings|Review Settings]]
|-
|[[Listware for Excel:Global:Processing|Processing]]
|-
|[[Listware for Excel:Global:Review Results|Review Results]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}
 


{{CustomTOC}}
{{CustomTOC}}

Latest revision as of 23:47, 31 May 2018

← 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



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.