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:
- A NULL of type int, it is converted to a 0.
- A NULL of type string, is converted to an empty string.
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