lookup?

[#1]

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

[dinuwanbr]

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

[#3]

even i tried no use

[dinuwanbr · Accepted solution]

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

     A,

     B,

     C,

     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