How to acumulate a column by LOAD Script?

Mon, 25 Jun 2012 15:39:46 GMT

Hi Folks,

I have a little problem with LOAD Script.

I have a Excel sheet like this:

And I would like to acumulate the column "Period in Use", but I can´t do it in script!!

I'd tried using the function above in Load Script, but it is not run correctly what I want.

I would like transform that datas in a new table like this:

Because I need to use the column Acumulate for a Simple Graph Table.

I don´t want to do it on a Graph Bar Table or Graph Pivot...

Have anyone of you a idea?

Thank you so much.

Re: How to acumulate a column by LOAD Script?

swuehl — Mon, 25 Jun 2012 15:51:54 GMT

Rodrigo,

try using the peek() function, not above(), like

Acc:

LOAD Date,

Hour,

[Period in Use],

interval(rangesum(peek(Accumulated),[Period in Use])) as Accumulated

FROM

(html, codepage is 1252, embedded labels, table is @1);

Mon, 25 Jun 2012 15:57:49 GMT

Perfect, my friend!!

I'd tried with peek() but incorrectly!

Your script runs ok!!

Thank you so much!