How to implement below function - during Load

Fri, 26 Aug 2011 15:50:43 GMT

I have table like below

Item, Periodstart,value

101,20091, 20092,100

102,20092,200903,200

103,200903,20105,500

104,20105,201108,700

I would like to introduce Periodend - read the value from below of the period start

Chart - below function will work.

how to do it in the load.

advance thanks for your help

101,20091, 100

102,20092,200

103,200903,500

104,20105,700

I am expecting the value

Item ,periodstart,periodend,value

Fri, 26 Aug 2011 16:08:51 GMT

Hi,

You can use order by Periodstart desc and then use the function previous():

load Item,

Periodstart,

previous(Periodstart) as periodend,

value

from...

order by Periodstart DESC;

Hope this helps

Regards!

topic How to implement below function - during Load in QlikView