LOOKUPTABLEVALUE2

Syntax

LOOKUPTABLEVALUE2 (table_name, expression)

Description

Takes a value in column 1 of the named lookup table to find the value in column 2.

Arguments

table_name The name of the lookup table.
expression A value in column 1 of the named lookup table. The value can be any string expression.

Returns

The corresponding value in column 2 of the lookup table.

Remarks

If no corresponding value is found, then TIBCO Cloud™ Integration - Connect returns an error and the record is not processed. See LOOKUPTABLEVALUE2_DEFAULT for more information.

If the lookup value or the value being looked up is a NULL, the value is converted to its native data type, and then, if necessary, converted to a string before it is used in the lookup. Before the lookup occurs, if the source value is:

If the value in the expression argument is listed more than once in the lookup table, TIBCO Cloud™ Integration - Connect returns a row error.

Example

If MyLookupTable contains the following data:

Column1 Column2

1

Manager

2

Vice President

3

Exec VP

4

CEO/Pres

 

LOOKUPTABLEVALUE2 ("MyLookupTable", "3" )

Returns: Exec VP

Related Topics

Lookup Tables

Lookup Functions

LOOKUPTABLEVALUE1

LOOKUPTABLEVALUE2_DEFAULT