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 :

       

      Table1:

      LOAD A as ID,

          B as mont,

          C

      FROM

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

      (ooxml, embedded labels, table is Feuil1);

       

      Data:

      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 ?