| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
This operator left joins two tables (left, right) on left.lookupFields = right.lookupFields and adds fetchFields column to the left table. This operator is useful if the input table has numerous columns, which can make it difficult to use a simple join.
...
Input
table A with (f1, f2, f3) columns,
f1 | f2 | f3 |
|---|---|---|
a | 2 | 3 |
LQL command
| Code Block |
|---|
B = select f1 as u1, SIZE(f2) + SIZE(f3) as val, f2 as u2 from A C = lookup(A,"[(f1, u1, match-case), (f2, u2)]", B, "[(val, val2)]") -- C should be a table A with additional "val" column -- The operator should produce the same output as -- select f1, f2, f3, val as val2 from A join B on upper(A.f1) = upper(B.u1) and A.f2 = B.u2 |
...