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