1 Reply Latest reply: Nov 15, 2014 1:06 AM by anbu cheliyan RSS

    Lookup on two columns

      Is it possible to  use lookup function on two columns.

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

        • Re: Lookup on two columns
          anbu cheliyan

          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 ];