Lookup on two columns

[#1]

Is it possible to  use lookup function on two columns.

Can we concatenate those two columns and use that new alias to lookup

[anbu1984]

Yes, you have to concatenate two columns.

Lookup:

Load Country & City As Key,Population Inline [

Country,City,Population

INDIA,MUMBAI,1C

INDIA,CHENNAI,.5C

INDIA,BANGALORE,.6C ];

State:

Load *,Lookup('Population','Key',Country & City,'Lookup') As Pop  Inline [

Country,State,City

INDIA,MH,MUMBAI

INDIA,TN,CHENNAI

INDIA,KA,BANGALORE ];