Lookup() function not working as expected.

[#1]

Hi,

If I run the following code it produces an error. Field not found <descr>. It appears the table argument in the lookup function is being ignored. Am i doing something wrong?

[]

t1:
LOAD * INLINE [
index,descr
1,'Active'
];

t2:
LOAD * INLINE [
ProdCode, Status_index
D456785,1
];

t3:
LOAD *,
LOOKUP(descr,index,'1','t1') as Satus_descr
RESIDENT t2

[/]

Mark

[johnw · Accepted solution]

You need single quotes around the field names in the lookup() function. I'm not saying I agree with this syntax, mind you, just that it is what it is. Also, since index is a numeric literal, I don't think it shoudl have single quotes. So I'm hoping this works?

lookup('descr','index',1,'t1')

[#3]

Thank you