adding data to existing qvd

[farolito20]

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]

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]

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

[CELAMBARASAN]

When you will delete?

[farolito20]

yes    

[CELAMBARASAN]

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);