Append QVD

Tue, 08 Mar 2011 11:57:59 GMT

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.

Append QVD

tresB — Tue, 08 Mar 2011 12:18:30 GMT

Try this:

replace your

'Concatenate' with 'Concatenate(BSEG)'.

Regards, tresesco

topic Append QVD in QlikView

Append QVD

Append QVD