Lookup Tables
Use the Lookup Tables panel to add, modify, or remove lookup table definitions. Lookup tables make writing expressions easier. Expressions that use a lookup table are shorter, as data entered in lookup tables is used in the LOOKUP expression. The LOOKUP expression is found in the Internal Functions category of any option that uses an expression builder interface. Lookup tables can be used to populate values in activity types, attributes or the summary report.
Instructions
On the Setup tab, in the Settings group, click Lookup Tables to display the Lookup Tables interface.
General Workflow
- Click the green + button in the upper left corner of the panel to add a new lookup table, or click a lookup table name to edit an existing lookup table.
- Click the green + button at the bottom left corner of the Lookup Tables panel to add new Value columns to the Details grid.
- Complete the grid with Key names and appropriate values.
Lookup Tables
Adding and Defining a New Lookup Table Definition
Click Add to add a new entry, or press the INSERT key on your keyboard.
Modifying a Lookup Table
Select an entry and modify the displayed information as needed.
Copying a Lookup Table
Select an entry and click Copy to create a copy of the selected entry or press Ctrl+ C.
Removing a Lookup Table
Select an entry and click Remove to remove the selected entry or press Delete. The entry can only be removed if it is not being used in the project.
Moving a Lookup Table
Select an entry and click Up or Down
to move the entry up or down in the list, or press Ctrl + Up arrow or Ctrl + Down arrow.
General
Name
Enter a name for the lookup table definition.
Description
Enter a brief description of the lookup table definition.
Details
Key
Enter text that will serve as the key for that entry in the lookup table definition.
Value 1, Value 2, Value 3...
Enter a value in each column.
Add
Click the Add icon below the table to add a new value column to the table.
Remove
Click the Remove icon below the table to remove the last value column from the table.
-
Column names in the Details grid are set. Associate column names with the values they contain in the Description field for the table.
-
To create a new row in the Details grid, complete the Key column and the Value 1 column, then press [Enter].
-
Click the green + button at the bottom of the Lookup Tables panel to add new Value columns to the Details grid.
-
Click the red - button at the bottom of the Lookup Tables panel to delete the last value column in the Details grid.
-
To remove an unwanted row in the Details grid, select the row and press [Delete].
-
When the lookup expression asks for the value column, the Value 1 column in the lookup table = 1 and the Value 2 column in the lookup table = 2. The Key column in the lookup table does not have an associated value number.