The following steps describe the process to test the parse asset with name data that you import. When you test the data, you might find names that the asset does not parse. You can then add the patterns for the unparsed names to the asset logic.
Open the parse asset that you created for pattern-based parsing.
Select the
Configuration
tab.
Select a Secure Agent to run the test.
To refresh the list of active Secure Agents, click the
Refresh
icon.
Import a sample of the source data that the Parse transformation will run on.
Use the Import option in the
Test Results
pane to import the data from a CSV or Microsoft Excel file. The sample data must populate the first column in the file.
The input data appears in the
Inputs
column.
Click
Test
.
The output columns display the test results.
Review the results of the test:
Find any input name that the test did not parse. Look for input names in the
Unparsed Data
field.
If you find a name that did not parse, make a copy of the pattern that the test assigned to the name.
The test writes the pattern for each name to the
Labeled Name
field. Copy the pattern from the Labeled Name field to a CSV or Microsoft Excel file.
Import the file that contains the pattern to the asset.
Use the
Add User-Defined Patterns
option to import the data. The patterns must populate the first column in the file.
You can import up to 5,000 user-defined patterns to a parse asset from a file that you specify.
Map the values in each pattern to an appropriate field in the pattern grid. For each value, select the field that best matches the type of information that the value represents.
Use the number in each pattern value as a guide when you map the values. The numbers match the order in which the data values appear in the input row. The numbered values in each pattern begin at (0).
After you map the pattern values to the appropriate fields, run the test again and review the results.
You may decide to import additional patterns to further update the pattern parsing logic.
When you are satisfied with the performance of the parsing operation on your sample data, save the asset.