Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to use lookup function on two columns.
Can we concatenate those two columns and use that new alias to lookup
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 ];