Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a number of csv files in a directory.
For instance...
On Day 1 I read these into a qvd called TMDATA1 using scriptbelow:
TMDATA:
LOAD [Paver ID], [Fleet ID], Date, Time, Longitude, Latitude, Satellites, Odometer, Pressure, Temperature, Humidity, Windspeed, [Hopper Temp.], [Auger Temp.], [Screed Temp. left], [Screed Temp. right], Barcode, Chainage, [Running Chainage], Remarks, 1 as Count FROM*.csv
Store TMDATA INTO $(vTMDATA-CSV)TMDATA1.qvd(qvd);
Csv files A.csv,B.csv,C.csv will then be deleted from the directory
On Day 2, D.csv,E.csv,F.csv willbe ftp’d into the same directory.
I then want to append these intothe TMDATA1.qvd
Is there an easy way to do this ?
I tried doing an “add load” butthis deleted everything from Day 1?
Thanks
I think what you need here is an incremental load.
There are plenty of threads here in the forum that are talking about this (as far as I remember, also a chapter in the reference manual).
You can find a well documented sample in the QV cookbook, available for download here:
http://robwunderlich.com/downloads/
Hope this helps,
Stefan