topic Lookup() function not working as expected. in QlikView

Lookup() function not working as expected.

Tue, 26 Jan 2010 22:49:36 GMT

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

Lookup() function not working as expected.

johnw — Tue, 26 Jan 2010 23:52:38 GMT

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')

Lookup() function not working as expected.

Wed, 27 Jan 2010 00:05:52 GMT

Thank you