15 Replies Latest reply: Sep 20, 2016 6:45 AM by Jayaseelan K RSS

    Double Counting in Concatenation

    Mohammad Sarif

      Hi All,

       

      I have two QVD files. Sales and Sales_New.

       

      Sales:

       

        

      DateSales
      1/1/2016100
      1/2/2016200
      1/3/2016300

       

      Sales_New:

       

        

      DateSales
      1/4/2016400
      1/5/2016500

       

      When I am trying to concatenate using below script, the records from Sales table is double counting.

       

      Sales:

       

      LOAD Date,

           Sales

      FROM

      Sales.qvd

      (qvd);

       

      Concatenate

       

      LOAD Date,

           Sales

      FROM

      Sales_New.qvd

      (qvd);

       

      If I am using not exists (date). then it is fine. Why the above script showing double counting data? As per my understanding it should not.

      Please advise.

       

      Thanks,

      Sarif