Listware for Excel:Global: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 58: | Line 58: | ||
;[[Listware for Excel:Global:Cleansing Operations|Cleansing Operations]] | ;[[Listware for Excel:Global:Cleansing Operations|Cleansing Operations]] | ||
Check the operation(s) you want to perform and specify your origin country, output script, and default country. | :Check the operation(s) you want to perform and specify your origin country, output script, and default country. | ||
;[[Listware for Excel:Global:Input Columns|Input Columns]] | ;[[Listware for Excel:Global:Input Columns|Input Columns]] | ||
Specify the input fields you want to process by selecting them in the drop-down menus. | :Specify the input fields you want to process by selecting them in the drop-down menus. | ||
;[[Listware for Excel:Global:Output Columns|Output Columns]] | ;[[Listware for Excel:Global:Output Columns|Output Columns]] | ||
Specify what data you want to output by checking the box next to the desired fields. | :Specify what data you want to output by checking the box next to the desired fields. | ||
:<span style="color:red;">'''Note: Any output data property must be specified as an input field unless you are using the Append action.'''</span> | :<span style="color:red;">'''Note: Any output data property must be specified as an input field unless you are using the Append action.'''</span> | ||
;[[Listware for Excel:Global:Reporting|Reporting]] | ;[[Listware for Excel:Global:Reporting|Reporting]] | ||
Listware now gives you the option of creating an additional sheet of processing statistics for a completed process. | :Listware now gives you the option of creating an additional sheet of processing statistics for a completed process. | ||
;[[Listware for Excel:Global:Review Settings|Review Settings]] | ;[[Listware for Excel:Global:Review Settings|Review Settings]] | ||
Review the settings you have selected and fix any errors. When you are ready, click 'Process!' to process your file. | :Review the settings you have selected and fix any errors. When you are ready, click 'Process!' to process your file. | ||
;[[Listware for Excel:Global:Processing|Processing]] | ;[[Listware for Excel:Global:Processing|Processing]] | ||
Processing will display the progess of your data cleansing. | :Processing will display the progess of your data cleansing. | ||
;[[Listware for Excel:Global:Review Results|Review Results]] | ;[[Listware for Excel:Global:Review Results|Review Results]] | ||
Once processing is completed, this step will display. You may take this opportunity to review, restart, or close the process. | :Once processing is completed, this step will display. You may take this opportunity to review, restart, or close the process. | ||
[[Category:Listware for Excel]] | [[Category:Listware for Excel]] | ||
Revision as of 21:39, 16 September 2014
← Listware for Excel Reference
| Global Check and Verify Navigation | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| ← Check and Verify | |||||||||
| Overview | |||||||||
| Tutorial | |||||||||
| |||||||||
|
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.