Names into Parts

Description

Splits the value of a single name column into its component name parts.

When you apply this transformation, Monarch Data Prep Studio asks you which of the following name components are available:

    • Prefix

    • First Name

    • Middle Name

    • Last Name

    • Last Name

    • Suffix

Monarch Data Prep Studio will do the name split depending on the components you selected on the dialog box.

 

Input/Output Data Type

Input

Output

text

text

 

Example

In the example below, Name is the original column, and the remaining three fields to the right are the result of the name split into First Name,  Middle Name, and Last Name.

 

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support