Split record during load by distribution key

[#1]

Hello all,

I have a new question. We want to compare our costs versus our income.

Tthe company has several plants. And some costs can't be addresses to one plant.

So they created a distribution key that counts for all costs that can't be addresses to one specific plant.

for example:

We have a cost of €1000.

     plant 1 gets 50% = €500

     plant 2 gets 20% = €200

     plant 3 gets 30% = €300

Can I split this up during the load of Qlikview?

In stead of having 1 record of €1000, I want three records.

thank you for your help.

Stijn

[MK_QSL]

This is For Loop of QlikView Script.

I have used For Loop and Peek Function which you can read from QlikView Reference Manual.