1 Reply Latest reply: Jan 28, 2010 6:56 AM by Bhushan Nirgude RSS

    Another lookup funtion quesiton (multiple selection criteria needed)

      Hello,

      Is it possible to use the lookup function to return the descr field where the index is 1 and MenuCode is 246?

      I have tried and failed!


      t1:
      LOAD * INLINE [
      index,MenuCode,descr
      1,247,'Blah'
      1,246,'Active'
      ];

      Regards

      Mark

        • Another lookup funtion quesiton (multiple selection criteria needed)
          Bhushan Nirgude

          Hi Rovers ,

          I can provide you the syntax of vlookup command , you can use it as per for your needs .

          Sytax for vlookup

          lookup('requiredcolumnfrmMaster','lookupcolumnfrmfrmMaster',[lookupcolumnfrmdestination],'Mastertablename'')

          In your case you can combine "index" and "MenuCode" field & do the lookup on destination table.

          something like :

          t1:
          LOAD * INLINE [
          index,MenuCode,descr,index_MenuCode
          1,247,'Blah',,'1,247'
          1,246,'Active',,'1,246'
          ];

           

          Cheers

          Bhushan N

           

           

           

          Regards,

          Bhushan N