Appending more csv data to an existing qvd

[timsaddler]

  Hello

I have a number of csv files in a directory.

For instance...

1. A.csv
2. B.csv
3. C.csv

On Day 1 I read these into a qvd called TMDATA1 using script
below:

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 will
be ftp’d into the same directory.

I then want to append these into
the TMDATA1.qvd

Is there an easy way to do this ?

I tried doing an “add load” but
this deleted everything from Day 1?

Thanks

[swuehl]

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