...
Join two tables (left, right) basd on a matching input field (left.inputField = right.lookupField) and add a fetchField column to the first (left) table. This operator is useful if the input table has numerous columns, which can make it difficult to use a simple join.
Usage Details
LQL Command
| Code Block |
|---|
lookupOperator(table, inputField, lookupTable, lookupField, fetchField) |
...
Output
The output table is the same as input table with an additional column named fetchField. If a fetchField column already exists in the input table the original one is dropped.
Example
Input
table A with (f1, f2, f3) columns,
...