Hey,
I am trying to work with lookup table where input contains 3 fields (A,B,C) and output is D
Lookup table structure:
A | B | C | D |
a | b | d |
Here is my configuration:
props.conf:
LOOKUP-result = lookup_table A B C OUTPUT D
transform.conf:
[lookup_table]
filename...
When I run query where there is no field named C (for example: A=a, B=b), the returned output is "a" which is not what I expect it to be "d".
What am I missing here? How can I fix it?
Try something like below:
LOOKUP-result = lookup_table A as A, B as B, C as C OUTPUT D