"split" accumulation in load-script

[t_hylander]

Im dried out of ideas how to search for this.

I have a dataset with a date and a accumulative data-column, like this;

20160116, 100

20160117, 102

20160118, 105

20160119, 108

but I want it to also have a third column;

20160116, 100, 0

20160117, 102, 2

20160118, 105, 3

20160119, 108, 3

Can anyone help me?

[Gysbert_Wassenaar · Accepted solution]

Something like this should work:

LOAD

     Date,

     Amount,

     Rangesum(0,Amount-Previous(Amount)) as Difference

FROM

     ...source...

     ;