2 Replies Latest reply: Feb 28, 2013 9:24 AM by Steven Eysenbrandts RSS

    Load Script: Using Lookup() in an If statement

      Hello,

       

      I am wondering if it is possible to use Lookup() in an if statement. Below you can see an example:

       

      Bron1:

      LOAD Para1,

           Doel as A

      FROM

      TEST_QV.xlsx

      (ooxml, embedded labels, table is C);

       

      Fact:

      LOAD Nr,

           Para1 AS P1,

           Art As Art1,

           If(Para1='B1',lookup('Doel','Para1',Para1,'Bron1'),'A')  AS Doel    

      FROM

      TEST_QV.xlsx

      (ooxml, embedded labels, table is A);

       

       

      See the attached file and the result.