"split" accumulation in load-script

t_hylander — Fri, 26 Feb 2016 13:18:19 GMT

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?

Re: "split" accumulation in load-script

Gysbert_Wassenaar — Mon, 29 Feb 2016 17:04:22 GMT

Something like this should work:

LOAD

Date,

Amount,

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

FROM

...source...

;