Pentaho/Contact Zone:SmartMover:Input

From Melissa Data Wiki
Jump to navigation Jump to search

← Contact Zone

← Data Quality Components for Pentaho

SmartMover Navigation
Overview
Tutorial
Advanced Configuration
Web
SmartMover Tabs
Input Columns
Output Columns
Processing Options
Pass-Through Columns
Output Filter
Result Codes



The Input Columns tab configures the fields that will be used for the Change-of-Address lookup of the SmartMover Component, as well as the input for name splitting and address parsing.

PENT SmartMover Input.png

To identify a changed address, the following fields are required for each record:

  1. Either FirstName and LastName, FullName or Company
  2. Address
  3. Either City and State, and or ZIP

Existing field names are selected using the dropdown boxes.

Input Name

Name Format

Full Name
If this is an individual person's address and the entire name is stored as a single string, pass the contents of that field here.
If the contact Name is already parsed, the Component can use information via the fields below.

Parsed Components

Prefix
This would be a title or honorific such as "Mr," "Miss," or "Dr."
First Name
This field accepts the given name for each record containing an individual address.
Middle Name
This field accepts an individual's middle name if one exists.
Last Name
This field accepts the family name for each record containing an individual address.
Suffix
This field accepts any part of the name that follows the family name, such as degrees ("MD" or "PhD") and generational indicators ("IV" or "Jr."), if one exists.


Input Address

Company
If the database records may be business type, include the company field here.
Address
Select the field in the input database that contains the first line of street address infor­mation. It may also contain secondary address information such as suite and private mailbox numbers.
Address2
Select the field in the input database that contains the second line of street address information, if any.
City
Select the field in the input database that contains the city information.
State/Province
Select the field in the input database that contains the state information.
Zip/Postal Code
Select the field in the input database that contains the postal code information.
Country
Select the field containing the country of the input data.


Additional Input Columns

PENT SmartMover AdditionalInput.png

Suite
Select the field in the input database that contains the Suite address information, if any.
Private Mailbox
Select the field in the input database that contains the Private Mailbox number, if any.
Urbanization
Select the field in the input database that contains the urbanization information, if any.
Urbanization is used to break ties between similar addresses in Puerto Rico. The urbanization name tells the address checking logic in which "neighborhood" to look, if more than one likely address candidate is found.
If just one address is found, the address checking logic can correct the address and return the urbanization name.
Plus 4
Select the field in the input database that contains the Plus 4 extension for US ZIP codes, if this information is stored separately.