topic Cumulative load in App Development

Cumulative load

msantarone — Wed, 11 Jul 2018 15:29:22 GMT

Given the following data source:

I need to obtain through a LOAD:

sunny_talwar — Wed, 11 Jul 2018 16:17:44 GMT

Try this

Table:

LOAD * INLINE [

Material, Period, Quantity

1, 201801, 12

1, 201801, -3

1, 201802, -2

2, 201801, 18

2, 201801, -3

2, 201801, -5

2, 201802, 3

];

FinalTable:

NoConcatenate

LOAD Material,

Period,

If(Material = Previous(Material), RangeSum(Peek('Quantity'), Quantity), Quantity) as Quantity;

LOAD Material,

Period,

Sum(Quantity) as Quantity

Resident Table

Group By Material, Period

Order By Material, Period;

DROP Table Table;