6 Replies Latest reply: Feb 6, 2014 2:05 PM by manoj kumar RSS

    exists function pls apply it for this tables

    manoj kumar

      exists function pls apply it for this tables

       

       

       

       

      tab1:

      LOAD id,

           a,

           c,

           f,

           g

      FROM

      exists.xlsx

      (ooxml, embedded labels, table is Sheet1);

       

       

      tab2:

       

       

       

       

      LOAD id,

           a,

           b,

           c

      FROM

      exists.xlsx  where exists(id);

      (ooxml, embedded labels, table is Sheet2);

       

       

       

       

       

      PLS MAKE THIS SCRIPT CORRECT BY USING EXISTS FUNCTION .I AM Q QLIKVIEW LEARNER PLS..........................

       

       

      WHERE TO WRITE SYNTAX CORRECTLY