Table Lookup

The table lookup mapping function is used to cross-reference one value to another value using a table. Because a QIE table can have any number of columns and any column can act as the source or target at lookup time, a single table can support several different cross-references. See System Variables for details.

Table

Select the desired table from the drop-down list. All tables (system variables of type 'table') in the current scope are listed in the drop-down list (see System Variables).

Find in

Select the column from the drop-down list that acts as the source value column for the table lookup.

Set to

Select the column from the drop-down list that acts as the new value column for the table lookup.

The Set to column can be the same column as Find in. A lookup configured that way confirms that the source value exists in the table without translating it. Combine it with an If not found action of Generate error to send a value that is missing from the table to the error queue, or with Use default value to substitute a placeholder.

The match is case-insensitive, and the value written to the target is the value stored in the table rather than the value that was searched for. A same-column lookup can therefore rewrite the case of the value it matched: if the message carries 'abc' and the table row holds 'ABC', the target is set to 'ABC'. Where the target is the same field the lookup read, that field is quietly canonicalized to the table's spelling. Match the case in the table to the case in the message when you want the value left exactly as it arrived.

If not found

This field controls how QIE responds if the source value is not found in the Find in column.

Not Found Action	Description
Generate error	The message is sent to the error queue
Use default value	The new value is set to the Default value specified
Use source value	The source (original) value is returned as the new value

Default

When the If not found action is set to Use default value, the desired default value is specified here.