I have a number of csv files in a directory.
On Day 1 I read these into a qvd called TMDATA1 using script
LOAD [Paver ID],
[Screed Temp. left],
[Screed Temp. right],
1 as Count
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
Is there an easy way to do this ?
I tried doing an “add load” but
this deleted everything from Day 1?
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:
Hope this helps,