8 Replies Latest reply: Jun 13, 2016 7:19 AM by Hans de Vries RSS

    Sum within load script

    Hans de Vries

      Hi Everyone,

       

      I have a table with payments. Main key is Dossier# and - among others - I have the fields payment date and amount payed.

      I need to make a copy of this table, in which all payments for one date are summarized. See example below. Can anyone help me out about how to achieve this in the load script?

       

         

      Dossier#Payment dateAmount
      100015-6-2016€ 1.000,00
      100014-6-2016€ 500,00
      100012-6-2016€ 800,00
      100012-6-2016€ 600,00
      100026-6-2016€ 400,00
      100026-6-2016€ 350,00

       

       

         

      Dossier#Payment dateAmount
      100015-6-2016€ 1.000,00
      100014-6-2016€ 500,00
      100012-6-2016€ 1.400,00
      100026-6-2016

      € 750,00