5 Replies Latest reply: Apr 24, 2015 7:11 AM by Ankita Agarwal RSS

    Problem with left join

      Hi everybody,

      I'm facing an issue while using left join in load script.


      I have for example this following script :



      LOAD A as ID,

          B as mont,



      [C:\Users\tchatch0\Desktop\Test July\Classeur1.xlsx]

      (ooxml, embedded labels, table is Feuil1);



      LOAD * INLINE [

      ID, Type, Value

      1, X, 10

      2, X, 20

      4, Y, 30



      Left join (Data)


      LOAD ID,

          mont - Value as Mont_Value

      resident Table1;


      My problem is that I can not use the field Value from table Table1 while joining.

      Is there a way to do this in qlikview ?