Listware for Excel:US:Cleansing Operations - Revision history

Admin at 23:49, 26 December 2019

2019-12-26T23:49:28Z

← Older revision		Revision as of 23:49, 26 December 2019
Line 43:		Line 43:


	For more information on Melissa Data Credits, please see [~~http~~://www.~~melissadata~~.com/~~dqt~~/~~credit-summary.htm~~ Credit Costs].		For more information on Melissa Data Credits, please see [https://www.melissa.com/pricing/listware Credit Costs].


	[[Category:Listware for Excel]]		[[Category:Listware for Excel]]

Admin at 23:57, 31 May 2018

2018-05-31T23:57:13Z

@@ Line 1: / Line 1: @@
-[[Listware for Excel:Reference|&larr; Listware for Excel Reference]]
+{{LWEUSNav
+|StepsCollapse=
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+}}
 {{CustomTOC}}

Admin at 21:02, 19 September 2014

2014-09-19T21:02:13Z

← Older revision		Revision as of 21:02, 19 September 2014
Line 83:		Line 83:
	;Credit Usage		;Credit Usage
	:Displays the estimated credit usage of your data cleansing process.		:Displays the estimated credit usage of your data cleansing process.


			For more information on Melissa Data Credits, please see [http://www.melissadata.com/dqt/credit-summary.htm Credit Costs].


	[[Category:Listware for Excel]]		[[Category:Listware for Excel]]

Admin at 21:33, 15 September 2014

2014-09-15T21:33:35Z

← Older revision		Revision as of 21:33, 15 September 2014
Line 6:		Line 6:
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|
	\|-		\|-
	\|[[Listware for Excel:Check and Verify\|← Check and Verify]]		\|style="border-bottom:1px solid #aaaaaa;"\|[[Listware for Excel:Check and Verify\|← Check and Verify]]
	\|-		\|-
	\|[[Listware for Excel:US\|Overview]]		\|[[Listware for Excel:US\|Overview]]

Admin at 21:31, 15 September 2014

2014-09-15T21:31:41Z

← Older revision		Revision as of 21:31, 15 September 2014
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 Navigation'''		! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''US Check and Verify Navigation'''
	\|-		\|-
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|
			\|-
			\|[[Listware for Excel:Check and Verify\|← Check and Verify]]
	\|-		\|-
	\|[[Listware for Excel:US\|Overview]]		\|[[Listware for Excel:US\|Overview]]

Admin: Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

2014-07-03T22:05:51Z

Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

New page

[[Listware for Excel:Reference|← Listware for Excel Reference]]

{| 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 Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Listware for Excel:US|Overview]]
|-
|[[Listware for Excel:US Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:US:Processing Range|Processing Range]]
|-
|[[Listware for Excel:US:Cleansing Operations|Cleansing Operations]]
|-
|[[Listware for Excel:US:Input Columns|Input Columns]]
|-
|[[Listware for Excel:US:Output Columns|Output Columns]]
|-
|[[Listware for Excel:US:Reporting|Reporting]]
|-
|[[Listware for Excel:US:Review Settings|Review Settings]]
|-
|[[Listware for Excel:US:Processing|Processing]]
|-
|[[Listware for Excel:US:Review Results|Review Results]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

[[File:LWE_US_Operations.png|link=]]

Check the operation(s) you want to perform.

The following operations are available:

;Check
:Check is always performed as a default. The Check action determines whether the data within a submitted record is valid, e.g. whether or not a given postal code contains the given city. It can also make limited corrections and appends to the data. Check looks at each data point separately, the inputs you put in for email don't affect what Check does with an address. Check returns results codes that describe which inputs were invalid, valid, or corrected. It also returns the input data after it has been corrected and added.

;Verify
:The Verify action allows you to determine whether the input data points are associated with each other. By default Listware will use the input Address as the centric, or pivot piece of data. If no address is used as input, Listware will use phone and email in that order as the centric piece of data.

:For example, Listware will tell you whether the name, phone, and email on that record coincide with that address in our database.

:Verify only returns the results column with results codes describing what it found.

;Move Update
:Appends address data of contacts who have moved based off of multisource data.

;Append Names
:Appends missing name or company information if available.

;Append Addresses
:Appends missing address information if available.

;Append Phones
:Appends missing phone information if available.

;Append E-mails
:Appends missing e-mail information if available.

;Credit Balance
:Displays your credit balance.

;Credit Usage
:Displays the estimated credit usage of your data cleansing process.

[[Category:Listware for Excel]]