Pentaho:MatchUp:Matchcode Editor

From Melissa Data Wiki
Revision as of 17:11, 17 June 2015 by Admin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

← Data Quality Components for Pentaho

MatchUp Navigation
Overview
Tutorial
Advanced Configuration
On-Premise
MatchUp Tabs
Matchcode
Field Mapping
Options
Source Pass-Through Columns
Lookup Pass-Through Columns
Output Filter
Matchcode Editor
Matchcode List
Component List
Component Properties
Algorithms
Expression Elements
Matchcodes
Result Codes



The Matchcode Editor is a Windows-based application that creates and edits the matchcode file used by MatchUp Object. This program allows you to customize copies of the preset matchcodes or create new matchcodes from scratch.

PENT MatchUp MatchcodeEditor.png


Matchcode List

This top portion of the interface contains a list of all the matchcodes found in the current matchcode file.

To the right of the list are four buttons: Create Matchcode, Remove Matchcode, Copy Matchcode, and Rename Matchcode.

SSIS MU MatchcodeEditor Matchcode.png

Add a New Matchcode

  1. Click the Create Matchcode button.
  2. Type a name for the new matchcode in the pop-up and click OK. The Matchcode Editor will present a blank matchcode screen with no components.
  3. Add components.

Remove an Existing Matchcode

  1. Select the matchcode to be deleted.
  2. Click the Remove Matchcode button.
  3. Click Yes to confirm the deletion.

Make a Copy of an Existing Matchcode

  1. Select the matchcode to be copied.
  2. Click the Copy Matchcode button.
  3. Type a name for the new matchcode in the pop-up box and click OK.

Rename an Existing Matchcode

  1. Select the matchcode to be renamed.
  2. Click the Rename Matchcode button.
  3. Type a new name for the matchcode in the pop-up box and click OK.


Component List

Below the matchcode list is a list of components used by the currently-selected matchcode.

The list also shows the basic settings for each combination. The right side of the list contains a grid that shows the combinations in which component is used. For more information on how combinations of components are used, see Component Combinations.

SSIS MU MatchcodeEditor ComponentList.png

Add a New Component to the Matchcode

  1. Select the [Select Data Type] dropdown list.
  2. The Matchcode Editor displays a list of 35 available Data Types and an additional General Data Type to choose from.
  3. SSIS MU MatchcodeEditor ComponentItem.png
  4. Select the settings for the new component.
  5. You can click on the different sections of the added component for more settings.
  6. Click OK.
  7. The new component is added as the last component in the matchcode.

Remove a component from a matchcode

  1. Select the Component Data Type dropdown list.
  2. Navigate to the top of the list and select [Remove Component].
  3. Place the focus on another control and the component will be removed from the component list.

Change the order of components in a matchcode

  1. Click on the name of the component.
  2. Drag the component to the new position.