When you add a step to a labeler asset, Data Quality prompts you to define a step with a regular expression or with a dictionary.
The following image shows the options that you configure when you define a step with a dictionary:
The dictionary options include the following properties:
Labeler mode.
Indicates the type of labeling operations to perform on the input data.
Add Step option.
Adds a step to the asset. A step describes a labeling operation that a mapping can apply to an input data field.
Up and Down options.
Moves a step that you select up or down within the step sequence.
Step sequence.
Defines the order in which a mapping applies each step to the input field at run time. The mapping performs labeling operations in the order that you specify.
Options name.
Identifies the dictionary that you add to the step.
Test input field.
Contains the input data that the Secure Agent uses to test the steps in the labeler sequence.
Test output fields.
Contain the result of the test.
The test output fields contain the following data:
A copy of the input field data in which any dictionary value is replaced by the label that you specify.
A copy of the input field data in which the discrete input values use the output field delimiter that you specify. The field can also return the valid dictionary version of any input value that matches a dictionary value.
Import file option.
Imports data to the test panel.
Step type.
Identifies the type of step to which the properties apply.
Dictionary name.
Identifies the dictionary that the step applies to the input data. You select the dictionary.
Label name.
Specifies the label that the step applies to the values in an input string. You enter the label.
Casing option.
Specifies whether the step considers the character case of the input values that it compares to the dictionary values. For example, the character case may be relevant if you plan to label person names from an input string, as the person names may begin with an uppercase letter.
Clear the option if the character case is not relevant to the data that the step will examine.
Mode option.
Determines the labeling method. Choose Inclusive or Exclusive mode to label values that match or do not match the dictionary values. The default mode is Inclusive.
In Inclusive mode, the labeling operation assigns the label to any value that matches a value in the dictionary.
In Exclusive mode, the operation assigns a label to any value that does not match a value in the dictionary.
Standardization option.
Specifies whether the step will replace any input value that matches a dictionary value with the corresponding value from the valid column in the dictionary.
The step compares the input values to every value in the dictionary. If the input value matches a valid value, the step does not update the value. If you clear the option, the step does not standardize any input value that matches a dictionary value.
Valid dictionary column name.
Identifies the valid column in the dictionary that you select. The valid column contains the preferred versions of the values in the dictionary. The valid dictionary column is active when you select the standardization option.
ASK INFAPreview
