Parsing Personal Names

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.