5 Replies Latest reply: Jan 15, 2018 2:44 AM by Petter Skjolden RSS

    How to write MINUS operator while loading data from Qvd or Excel.

    krishna b

      Hi All ,

       

      How to write MINUS operator while loading data from Qvd or Excel.

       

      SELECT Column1, Column 2, ... Column _n

      FROM tables

      [WHERE conditions]

      MINUS

      SELECT Column 1, Column 2, ... e Column _n

      FROM tables

      [WHERE conditions];

       

      LOAD Column1,
          
      Column 2,
          
      Column 3,
               Column 4,
                Column 5
      FROM
      [C:\ A.QVD]
      (
      qvd);


      LOAD
           Column1,
         
      Column 2,
         
      Column 3,
               Column 4,
                Column 5

        FROM


      [C:\B.QVD]
      (
      qvd

      );

       

      Minus.png


      Regards,

      Krishna