Listware for Excel:Global: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{LWEGlobalNav}} | |||
{ | |||
{ | |||
{{CustomTOC}} | {{CustomTOC}} | ||
| Line 47: | Line 5: | ||
[[File:LWE_Global_Button.png|link=]] | [[File:LWE_Global_Button.png|link=]] | ||
Global Check & Verify can be accessed by clicking the 'Global' button | Global Check & Verify can be accessed by clicking the 'Global' button. | ||
| Line 56: | Line 14: | ||
;[[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 | :Processing will display the progress 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]] | ||
Latest revision as of 23:46, 31 May 2018
← Listware for Excel Reference
| Global Check and Verify Navigation | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| ← Listware for Excel Overview | |||||||||
| Overview | |||||||||
| Tutorial | |||||||||
| |||||||||
| Result Codes |
Global Check & Verify can be accessed by clicking the 'Global' button.
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 progress 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.