QVD File updation.

[vijayit43]

Hi Expert,

               We are creating a Dashboard we want to fetch data from current month to server and other data from QVD file how to create QVD and reload schedule to QVD Dynamically to update previous month data.

please suggest with example

[Anonymous]

Hi,

Use incremental load code below:

//First load current month data.
//So that we will read the records where modification time is greater than or equal to last execution time.
//After we load previous month data from existing QVD and Concatenate to the current month data and store it into QVD

Table:
SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
WHERE ModificationDate >= $(LastExecTime);
Concatenate
LOAD PrimaryKey, X, Y FROM Data.QVD;
STORE Table INTO Data.QVD;

Regards

Neetha

[Anonymous]

Find attached incremental load script and modify as your need.

Thanks

BKC