Peek vs Previous - Use Last Number PLUS!!

[cpiocpio]

Hi all

I am back.

After an excellent response yesterday, I thought thats one in the bag, move on, but no.

The requirement has been extended.

Still generating missing dates, and repeating previous values but PER machine

So in the attched, i have used INLINE and out in only a few rows, in 3 coloumns

LOAD * INLINE [
    DataDate, MachineName, Mileage
    02/06/2009,SW81AA,638
    04/06/2009,SW88AA,1600
    05/06/2009,SW88AA,1600
    07/06/2009,33KM85,309
];

The required OUTPUT is, that it should repeat per Machine Name per day :

02/06/2009;"SW81AA";638

03/06/2009;"SW81AA";638

04/06/2009;"SW81AA";638

04/06/2009;"SW88AA";1600

05/06/2009;"SW88AA";1600

05/06/2009;"SW81AA";638

06/06/2009;"SW88AA";1600

06/06/2009;"SW81AA";638

07/06/2009;"33KM85";309

07/06/2009;"SW88AA";1600

07/06/2009;"SW81AA";638

Many thanks

[cpiocpio]

Once again, I say many thanks to all .

I had to nominate One answer as correct, but all had their merits. I chose Nicole Smiths as CORRECT, since nearest to desired results and did not involve any add-on scripts etc. ALL were great and very useful thought.

[cpiocpio]

Yes, thatnk you just posted a reply - been out and about