Dictionaries > Introduction to dictionaries > Dictionary configuration options
  

Dictionary configuration options

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 grid contains multiple rows and columns. The configuration options for the dictionary appear on the toolbar above the grid.
The dictionary contains the following options and elements:
  1. 1Row ID.
    2. Shows the current sequence of the dictionary rows. To highlight a row, select its row ID.
  2. 2Default valid value column.
    3. Contains the values that the transformation returns at run time by default. You can specify a different valid column when you configure the asset.
  3. 3Alternative value columns.
    4. Contains alternative or incorrect versions of the values in the default valid column.
  4. 4Download data to a file.
    5. Downloads the data in a dictionary to a comma-separated file.
  5. 5Import data from a file.
    6. Imports data to the dictionary.
  6. 6Add a filter query.
    7. 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.
  7. 7Add a row.
    8. Adds an empty row after the current final row in the dictionary.
  8. 8Sort the dictionary data.
    9. Sorts the data rows by values in one or more columns that you specify.
  9. 9Filter the current page of dictionary data.
    10. 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.
  10. 10Find and replace data.
    11. Finds and replaces a value that you specify.
    Note: 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.
  11. 11Settings menu.
    12. Determines the dictionary row height.
  12. 12Conversion options.
    13. Enables the dictionary for updates in the Data Quality user interface or updates through the Dictionary API. The option displays Convert to UI or Convert to API based on the current status of the dictionary. For more information about the dictionary conversion options, see Dictionary conversion options.
Note: A dictionary that you create from Reference 360 displays the Configuration tab. You can view the contents of the dictionary but can't edit them in Data Quality. To edit dictionary data, open the dictionary source in Reference 360.