[incremental load] Cannot manage to 1. load QVX 2. properly append new data to existing QVX

Wed, 26 Sep 2012 14:06:20 GMT

Hi!

I'm adventuring in the incremental load subject and I'm facing a couple of issues.

I created a qvx file where I stored my orders data and I wanted to do an incremental load with orders that were entered today.

This is how the script looks like

LOAD *,
order as KEY;
SQL SELECT * FROM DB.TABLE
WHERE LODTE >= '$(vToday)';
Concatenate LOAD *
FROM \\server\drive\folder\2012.qvx (qvd)
WHERE NOT Exists(KEY);
STORE DB.TABLE INTO \\server\drive\folder\2012_increment.qvx;

This is the only script version that I managed to make it works.

Please note that I had to enter the (qvd) parameter when loading the original QVX.

With this script the incremental load works as expected and the resulting data also matches expectations.

If I write instead

Concatenate LOAD *
FROM \\server\drive\folder\2012.qvx
WHERE NOT Exists(KEY);
STORE DB.TABLE INTO \\server\drive\folder\2012_increment.qvx;

so excluding the (qvd) parameter, it does not work.

So it seems like that qvx is not handled when making incremental loads?

Without the (qvd) parameter, it does not load; when I attempt to open the freshly created 2012_increment.qvx, QV recognises it as QVD in the wizard.

Second issue:

I cannot manage to integrate the current qvx with new information. I.e., if I write

Concatenate LOAD *
FROM \\server\drive\folder\2012.qvx (qvd)
WHERE NOT Exists(KEY);
STORE DB.TABLE INTO \\server\drive\folder\2012.qvx (qvd);

in order to fetch data from my qvx and integrate it with the freshly retrieved data from the DB, it does not work. It fails both if I use or not the (qvd) parameters.

Indeed if I read the reference manual, it writes:

QV_Table:
SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
WHERE ModificationTime >= #$(LastExecTime)#;
Concatenate LOAD PrimaryKey, X, Y FROM File.QVD
WHERE NOT Exists(PrimaryKey);
STORE QV_Table INTO File.QVD;

I'm using QV 10 if it is of any help.

Thanks!

topic [incremental load] Cannot manage to 1. load QVX 2. properly append new data to existing QVX in QlikView

[incremental load] Cannot manage to 1. load QVX 2. properly append new data to existing QVX