repeat value until new match in script

pepe2209 — Thu, 16 Jan 2014 14:57:55 GMT

Hello

I would like to achieve the following: now my table looks like this:

Date	StartDate	Value	Startvalue
16-01-2014	14-01-2014	5	3
15-01-2014	14-01-2014	4	3
14-01-2014	14-01-2014	3	3
13-01-2014	10-01-2014	20	17
12-01-2014	10-01-2014	19	17
11-01-2014	10-01-2014	18	17
10-01-2014	10-01-2014	17	17

I want to create the right column (Startvalue) in the script.

So when the startdate matches the date, the value recorded is the startvalue:

if(Date=StartDate, Value) as Startvalue.

But then this startvalue needs to be repeated for each following date until a new startdate matches the date.

How can i achieve this?

Your help would be much appreciated

regards,

Peter

Re: repeat value until new match in script

hic — Thu, 16 Jan 2014 15:01:24 GMT

if(Date=StartDate, Value, Peek(PropagatedValue)) as PropagatedValue

HIC

pepe2209 — Thu, 16 Jan 2014 15:24:42 GMT

Ok thanks, so that was rather easy