Lookup table definition: Table lookup

If it is a new table, then select Edit > New Item > Append.

Specify the input and output data values in the In and Out cells.

Use Edit > Trim Cells to remove extra spaces on table entries. Otherwise, the lookup table file would contain unnecessary spaces that could affect the behavior of the tbllookup command. This option is also available on the context menu when right-clicking a table entry.

Edit menu

  • Trim Cells

    Removes extra spaces on Lookup Table entries.

Table Control Values pane

Click Bi-directional to reconfigure the dialog box to reveal the side information for each pair.

If the table lookup fails, then selecting Use Original Value keeps the original value of the field being loaded from the table lookup.

Select Use Default Value to use what is defined in the field. Specify a default string to use for data conversion if an input data value is not in the lookup table.

For security, select Set Default Value as Masked Field.

See Table security.

Bi-directional operation

Bi-directional specifies that the table's data pairs translate in both directions (Side 1 to Side 2 or Side 2 to Side 1).

Data input values (or left-side input) must be unique. If using bi-directional pairs, then unique data output values, or right side, are required, as both sides are used for input.

Side 1 assigns a name to the entries on the left side of the table. Use this name to reference these values when configuring a table lookup with Translation Configurator. The default name for this side of the table is Input.

Side 2 assigns a name to the entries on the right side of the table. Use this name to reference these values when configuring a table lookup with Translation Configurator. The default name for this side of the table is Output.