2 Replies Latest reply: Oct 28, 2015 1:25 PM by Ramon Covarrubias RSS

    SUM duplicates in Load Script


      I have a problem in loading script. I don´t know what is wrong.


      In a QVD file with several columns I want to apply SUM function.

      let´s say:


      Year   Product     PRV     Amount

      2014   prdA          A          24720

      2014   prdB          A          24720


      I do apply SUM function like this:


      load PRV,SUM(Amount) as SAmount from QVD.qvd (qvd)

      group by PRV;


      Finally, when I create a Table from FINAL_QVD I get this:

      PRV     SAmount

      A          98880

      Instead of:

      PRV     SAmount

      A          49440