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

    SUM duplicates in Load Script

    Diego Sandoval

      Hello,

      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:

      FINAL_QVD:

      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