pivot with running_totals in load

[Anonymous]

Hi,

we have a table with about 20000 distinct keys.

For each key there are 104 weeks (in rows) with values.

For each key I have to create 104 new columns (pivoting) and calculate the running_total for one of the values.

Because it is hard to explain, I uploaded an very simple example with only 1 key and 4 weeks.

If you look at the values you for vw1 to vw4 you can see how the running totals have to be calculated.

Any idea how to do that in a load script?

Regards Roland