Pattern-based parsing options on the Configuration tab
Pattern-based parsing options on the Configuration tab
When you select Pre-built mode in the Configuration tab, Data Quality prompts you to specify the criteria for person name parsing.
The following image shows the options that you configure when you define the parsing operation:
The pattern-based parsing options include the following properties:
Type
Identifies the type of information that the parsing operation analyzes. Pattern-based parsing analyzes person name information.
Locale
Indicates the country of origin of the data that the parsing operation analyzes.
Format option
Specifies the format of the input
data that the parsing operation will read. The format indicates the sequence in
which the parsing operation expects to read the input data values.
The
parsing operation applies the built-in data patterns based on the format that
you select.
Add or Remove User-Defined Patterns option
Adds
patterns that you define to the built-in patterns that the current operation
uses. Or, removes all user-defined patterns from the current operation.
The asset imports user-defined patterns from a CSV or Microsoft Excel
file that you specify.
User-Defined Patterns
Lists any pattern that you add to the current parsing operation.
Pattern selection menu
Indicates the number of patterns that you select. You can use the menu to delete the rows or to erase the field mappings that you defined for the rows.
Pattern input fields
Displays the fields
to which you can map the values in a user-defined pattern. Select the
appropriate field for each value in any pattern that you add. The
Configuration
tab displays the fields based on the
locale and format you select.
Pattern data options
Provides options to
switch to full-screen mode, to import a pattern, to download a pattern as a
Microsoft Excel file, to add a row to a pattern, to search for a pattern, and to
sort the rows in your pattern by the output column names.
Row selection menu
Opens a set of options that you
can use delete the row or to erase the field mappings that you defined for the
row.