5 Replies Latest reply: Jul 14, 2017 7:21 AM by Antonio Mancini RSS

    How to create a table based on data from an existing table in script

    Eric Hetem

      Hi,

       

      Is it possible to create the right table based on the existing table on the left in a script ?

      My guess is that it can be done with For..Next.

       

      This is what I need:

      There is an record in an existing table with ID=A, start Date=June, Units=4 and Value =100.

      Based on this I would like to create a new table which has 4 (=Units) lines, each with an amount of Value/Units and a date which starts at the start date and increases with 1 month

        Snap31.png