topic Re: lookup? in QlikView

lookup?

Tue, 11 Nov 2014 03:58:45 GMT

t1:

LOAD [customer number],

[customer name]

FROM

E:\M\prac\mapping444\customer.xlsx

(ooxml, embedded labels, table is Sheet1);

t2:

LOAD year,

month,

[customer number],

[budget amount]

FROM

E:\M\prac\mapping444\budget.xlsx

(ooxml, embedded labels, table is Sheet1);

t3:

load *,

Lookup('[customer name]','[customer number]',[customer number],'t1') as cusmer

Resident t2;

pls correct me where i am wrong? because i am not getting any data for cusmer

Re: lookup?

dinuwanbr — Tue, 11 Nov 2014 04:11:25 GMT

Hi,

Try this

t1:

LOAD [customer number],

[customer name]

FROM

E:\M\prac\mapping444\customer.xlsx

(ooxml, embedded labels, table is Sheet1);

t2:

LOAD year,

month,

[customer number],

[budget amount],

Lookup('[customer name]','[customer number]',[customer number],'t1') as cusmer

FROM

E:\M\prac\mapping444\budget.xlsx

(ooxml, embedded labels, table is Sheet1);

t3:

load *

Resident t2;

BR,

dinu'1

Re: lookup?

Tue, 11 Nov 2014 04:21:21 GMT

even i tried no use

Re: lookup?

dinuwanbr — Tue, 11 Nov 2014 04:48:09 GMT

Hi,

Do some alias and try. Following code works fine to me. (example)

t1:

LOAD,

A as S,

B as V,

C as K

FROM

[New Microsoft Excel Worksheet.xlsx]

(ooxml, explicit labels, table is Sheet1);

t2:

LOAD

lookup('V','K',B,'t1') as D

FROM

[New Microsoft Excel Worksheet.xlsx]

(ooxml, no labels, table is Sheet2);

t3:

load D

Resident t2;

BR,

Dinu'1