Hi,
I am trying to append my qvd's so that I can add the previous day's data.
I always seem to get either of 2 issues when I try working this code.
1. The QVD concatenates the new fields with the old but all the old fields are renamed as BSEG-1…. Instead of BSEG
2. The fields are all the same name however old the new data is in the QVD.
This is the code that I am working with:
BSEG:
SQL
SELECT
*
FROM BSEG
WHERE creation_date >= sysdate -1
and creation_date < sysdate;
Concatenate
LOAD
BSEG.ID,
BSEG.CREATION_DATE
FROM
data\BSEG.qvd
(qvd)
where not exists(BSEG.ID);
STORE BSEG INTO data\BSEG_NEW.qvd(qvd);
I have tried using only the >= in the where clause and I have overwriting the current qvd and storing in a new qvd to see if the all the data is there but the same issues keep happening.
I really can't seem to get the desired result, can anyone help me?
Any help is much appreciated, thanks in advance.
