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?
