lookup input value null

[shayhibah]

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?

[thambisetty]

Try something like below:

LOOKUP-result = lookup_table A as A, B as B, C as C OUTPUT D