Difference between revisions of "Listware for Excel:Global"

From Melissa Data Wiki
Jump to navigation Jump to search
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:41, 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 Button.png

Global Check & Verify can be accessed by clicking the 'Global' button in the 'Check & Verify' section.


Global Check & Verify allows you to do Contact Verification. Each step can be navigated to by clicking the 'Next' or 'Previous' buttons. The steps are as follows:

Processing Range
Select the range of cells in your worksheet that you would like to process, then click the 'Select Data to Process' button.
Cleansing Operations

Check the operation(s) you want to perform and specify your origin country, output script, and default country.

Input Columns

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

Output Columns

Specify what data you want to output by checking the box next to the desired fields.

Note: Any output data property must be specified as an input field unless you are using the Append action.
Reporting

Listware now gives you the option of creating an additional sheet of processing statistics for a completed process.

Review Settings

Review the settings you have selected and fix any errors. When you are ready, click 'Process!' to process your file.

Processing

Processing will display the progess of your data cleansing.

Review Results

Once processing is completed, this step will display. You may take this opportunity to review, restart, or close the process.