You define and update the content and structure of a dictionary on the
Configuration
view.
You can select the
Configuration
view when you create or open a dictionary.
The following image shows the options that you can use to configure the dictionary:
The dictionary contains the following options and elements:
Row ID.
Shows the current sequence of the dictionary rows. To highlight a row, select its row ID.
Default valid value column.
Contains the values that the transformation returns at run time by default. You can specify a different valid column when you configure the asset.
Alternative value columns.
Contains alternative or incorrect versions of the values in the default valid column.
Download data to a file.
Downloads the data in a dictionary to a comma-separated file.
Import data from a file.
Imports data to the dictionary.
Add a filter query.
Opens the
Add Filter
query options.
The
Add Filter
query option appears in a dictionary that contains very large quantities of data. For information about very large dictionaries, see
Working with very large dictionaries.
Add a row.
Adds an empty row after the current final row in the dictionary.
Sort the dictionary data.
Sorts the data rows by values in one or more columns that you specify.
Filter the current page of dictionary data.
Displays the rows that contain a value that you specify in a column that you select. The option applies a filter on the current page in a dictionary.
Find and replace data.
Finds and replaces a value that you specify.
The Filter and Find and Replace options are linked. When the filter is active, you can find and replace data within the filtered results only.
ASK INFAPreview
