Incremental load

Hi,

This can be done as below.

1 st you have to define the variable path for vToday for increment data (this has to define if you want to segregate the date by data)

//Load existing data

Load *

from

Sample - Superstore Sales.qvd

(qvd);

concatenate

//Load incremental data to the above 

Load * from

[lib://Temp/Sample - Superstore Sales (Excel)$(vToday).xls]

(biff, embedded labels, table is Orders$)

//Store combine data in to qvd

Store Sample - Superstore Sales into Sample - Superstore Sales.qvd;

Drop table Sample - Superstore Sales;

//Refer the newly created "Sample - Superstore Sales.qvd"

Thanks

Amila

It depends on the characteristic of the data - different scenarios are possible. There's good article:

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/