1 Reply Latest reply: Dec 5, 2013 8:41 AM by Michele Barini RSS

    Generate new records from existing records

      I have to get some calculated line items get created in the script like:

       

      GenRecord.png

       

      Would appreciate any help.

        • Re: Generate new records from existing records
          Michele Barini

          Hi,

          you could do this adding a link table:

           

          LOAD * INLINE [

              ItemIn, Company, Amount

              1, A, 100

              1, B, 200

              1, C, 300

              2, A, 1000

              2, B, 2000

              2, C, 3000

              3, A, 10

              3, B, 20

              3, C, 30

          ];

           

          LOAD * INLINE [

              ItemIn, Item

              1, 1

              2, 2

              3, 3

              1, NewAc

              2, NewAc

          ];