Skip to content

Field Dictionaries

Overview

Field dictionaries translate a list of data codes to human readable values.

Assigning Field Dictionaries

To assign field dictionaries:

  1. Select the dataset in Mapworks UI
  2. Click Assign Dictionaries

Map fields / Assign Dictionaries

  1. Click the magnifying glass next to a field

Assign Dictionaries

  1. Search for and select a dictionary
  2. Click Add
  3. Click OK

Inspect dictionaries

Creating Field Dictonaries

To create a field dictionary:

  1. Go to Mapworks UI
  2. Click Mgt Console in the bottom left

Settings

  1. In the sidebar, click Field Dictionaries

Settings

  1. Click the Create Field Dictionaries icon on the right

Field Dictionaries settings

  1. Enter the dictionary values following the pattern (Code, Dictionary value)

Field Dictionaries settings

Alternatively, click Import Field Dictionaries to import the dictionary as a CSV file

Import CSV

Note: When importing field dictionaries by CSV, multiple dictionaries can be imported as single file using the format pictured below:

Import CSV Example

Import CSV Import

Conditional Field Dictionaries

Multiple dictionaries can be assigned to a field with a condition that checks another field's value to decide which dictionary is used in each case.

Field Dictionaries settings

To create conditional field dictionaries:

  1. Create a basic field dictionary for each condition
  2. Select the dictionaries and click the Create Conditional Field Dictionaries button on the right to convert them to be used conditionally

Convert Conditional Dictionaries

  1. Click the Conditional button to toggle the view to list conditional field dictionaries
  2. Add a condition to each dictionary
  3. Assign all relevant conditional dictionaries to the dataset field

Inspect Conditional Dictionaries