Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

timsaddler
Contributor II

Appending more csv data to an existing qvd

  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

1 Reply
MVP
MVP

Re: Appending more csv data to an existing qvd

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

Community Browser