Parsing Personal Names - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
Topic type
Overview
Reference
Tips
How Do I
First publish date
2007
ft:lastEdition
2024-03-04
ft:lastPublication
2024-03-04T22:52:13.486265

If you have name data that is all in one field, you may want to parse the name into separate fields for each part of the name, such as first name, last name, title of respect, and so on. These parsed name elements can then be used by other automated operations such as name matching, name standardization, or multirecord name consolidation.

  1. If you have not already done so, load the following tables onto the Spectrum Technology Platform server:
    • Open Parser Base
    • Open Parser Enhanced Names

    Use the Data Normalization database load utility to load these tables. For instructions on loading tables, see the Installation Guide.

  2. In Enterprise Designer, create a new dataflow.
  3. Drag a source stage onto the canvas.
  4. Double-click the source stage and configure it. See the Dataflow Designer's Guide for instructions on configuring source stages.
  5. Drag an Open Name Parser stage onto the canvas and connect it to the source stage.

    For example, if you are using a Read from File stage, your dataflow would look like this:

    Read from File in dataflow
  6. Drag a sink stage onto the canvas and connect Open Name Parser to it.

    For example, if you are using a Write to File sink, your dataflow might look like this:

    Write to File in dataflow
  7. Double-click the sink stage and configure it. See the Dataflow Designer's Guide for instructions on configuring source stages.

You have created a dataflow that can parse personal names into component parts, placing each part of the name in its own field.