Listware for Excel:US: Difference between revisions
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..." |
No edit summary |
||
| Line 43: | Line 43: | ||
|} | |} | ||
{{CustomTOC}} | |||
[[File:LWE_US_Button.png|link=]] | |||
US Check & Verify can be accessed by clicking the 'US' button in the 'Check & Verify' section. | |||
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: | |||
;[[Listware for Excel:US:Processing Range|Processing Range]] | |||
:Select the range of cells in your worksheet that you would like to process, then click the 'Select Data to Process' button. | |||
;[[Listware for Excel:US:Cleansing Operations|Cleansing Operations]] | |||
:Check the operation(s) you want to perform. | |||
;[[Listware for Excel:US:Input Columns|Input Columns]] | |||
:Specify the input fields you want to process by selecting them in the drop-down menus. | |||
;[[Listware for Excel:US:Output Columns|Output Columns]] | |||
: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> | |||
;[[Listware for Excel:US:Reporting|Reporting]] | |||
:Listware now gives you the option of creating an additional sheet of processing statistics for a completed process. | |||
;[[Listware for Excel:US:Review Settings|Review Settings]] | |||
:Review the settings you have selected and fix any errors. When you are ready, click 'Process!' to process your file. | |||
;[[Listware for Excel:US:Processing|Processing]] | |||
:Processing will display the progess of your data cleansing. | |||
;[[Listware for Excel:US:Review Results|Review Results]] | |||
: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 17:53, 3 July 2014
← Listware for Excel Reference
| US Navigation | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Overview | |||||||||
| Tutorial | |||||||||
| |||||||||
|
US Check & Verify can be accessed by clicking the 'US' button in the 'Check & Verify' section.
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 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.