Listware for Excel:US: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| 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;"|'''US Check | ! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''US Check and Verify Navigation''' | ||
|- | |- | ||
| style="padding-right:220px;"| | | style="padding-right:220px;"| | ||
Revision as of 21:30, 15 September 2014
← Listware for Excel Reference
| US Check and Verify Navigation | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| ← Check and Verify | |||||||||
| 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.