Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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.

1 Reply
bbi_mba_76
Valued Contributor

Re: Generate new records from existing records

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

];

Community Browser