topic Re: adding data to existing qvd in QlikView

adding data to existing qvd

farolito20 — Thu, 20 Dec 2012 22:13:52 GMT

How can I add extra data to a existing .qvd?

actualizacion:

load *

from DimCustomers_Day1.qvd (qvd)

Where Checksum>'$(vMax)';

store actualizacion into DimCustomers_Day0.qvd (qvd);

but when I did store line, all old data was delete and replace with actualizacion table 😕

CELAMBARASAN — Thu, 20 Dec 2012 22:19:51 GMT

First you need to load QVD file that you stored before.

Try this

actualizacion:

load *

from DimCustomers_Day0.qvd (qvd);

Concatenate //By default it will concatenate if you have same number of fields with same name.

load *

from DimCustomers_Day1.qvd (qvd)

Where Checksum>'$(vMax)';

store actualizacion into DimCustomers_Day0.qvd (qvd);

farolito20 — Thu, 20 Dec 2012 22:31:07 GMT

the concatenate don't work if I dlete something from the DimCustomers_Day0.qvd (qvd) ?

CELAMBARASAN — Thu, 20 Dec 2012 22:58:44 GMT

When you will delete?

farolito20 — Thu, 20 Dec 2012 22:59:43 GMT

yes

CELAMBARASAN — Thu, 20 Dec 2012 23:00:04 GMT

May be expecting this?

actualizacion:

load *

from DimCustomers_Day1.qvd (qvd)

Where Checksum>'$(vMax)';

//Your delete operations here

Concatenate (actualizacion) load *

from DimCustomers_Day0.qvd (qvd);//concatenate before you store

store actualizacion into DimCustomers_Day0.qvd (qvd);