PowerCenter
- PowerCenter 10.4.0
- All Products
LOOKUP(result, search1, value1 [, search2, value2]... )
Argument | Required/ Optional | Description |
---|---|---|
result | Required
| Any datatype except Binary. Must be an output port in the same lookup table as search. Specifies the return value if the search matches the value. Always preface this argument with the reference qualifier :TD.
|
search1 | Required
| Datatype that matches the
value1 . Must be an output port in the same lookup table as result. Specifies the values you want to match to value. Always preface this argument with the reference qualifier :TD.
|
value1 | Required
| Any datatype except Binary. Must match
search1 datatype. The values you want to search for in the lookup source column specified in
search1 . You can enter any valid transformation expression.
|
LOOKUP( :TD.SALES.ITEM_NAME, :TD.SALES.ITEM_ID, 10, :TD.SALES.PRICE, 15.99 )
|
|
|
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
LOOKUP(:TD.ORDERS.PRICE, :TD.ORDERS.ITEM, RTRIM( ORDERS.ITEM, ' '))
LOOKUP(:TD.ORDERS.ITEM, :TD.ORDERS.PRICE, ORDERS.PRICE, :TD.ORDERS.QTY, ORDERS.QTY)