Generate new records from existing records

[#1]

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

Would appreciate any help.

[bbi_mba_76]

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

];