1 Reply Latest reply: Apr 30, 2013 10:12 AM by Giovanne Bergstein RSS

    Script to accumulate data for financial statement year, months

      Hello community, I have the following situation:

       

       

      I loaded a table from a financial statement to group by qty of installments paid the payment year and months, it loads correctly however need to load a table with the amount of accumulated payments remembering that there are months that can not occur and even payments occur in other months, following code below:

       

       

      So I created a solution for using for loop, however I'm dealing with a database of over 1 million records and it is extremely slow to load, I need another solution.

       

      in waiting, thanks

       

       

      LOAD

        ID_DOC,

        YEAR,

         MONTH,

         count(DATE) AS PAY_MONTH

      Resident DOCUMENT

      Group by ID_DOC, YEAR, MONTH

      order by ID_DOC, YEAR, MONTH;