Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Yes, thatnk you just posted a reply - been out and about