2 Replies Latest reply: Jan 26, 2010 7:05 PM by BlackburnRovers RSS

    Lookup() function not working as expected.

      Hi,

      If I run the following code it produces an error. Field not found <descr>. It appears the table argument in the lookup function is being ignored. Am i doing something wrong?

       

      []

      t1:
      LOAD * INLINE [
      index,descr
      1,'Active'
      ];

      t2:
      LOAD * INLINE [
      ProdCode, Status_index
      D456785,1
      ];

      t3:
      LOAD *,
      LOOKUP(descr,index,'1','t1') as Satus_descr
      RESIDENT t2

       

      [/]

      Mark