topic Re: Adding to QVD without loading it in in QlikView

Adding to QVD without loading it in

Tue, 27 Jan 2015 22:43:27 GMT

Is there a way to add or concatenate to the QVD's without having to load them in first? I am looking for the optimal way to do incremental loading and insert new transactional data daily without having to load it up first.

Re: Adding to QVD without loading it in

jonasheisterkam — Tue, 27 Jan 2015 23:02:11 GMT

That would not work without reading file first, inside you have pointer to distinct values.

Re: Adding to QVD without loading it in

marcus_sommer — Wed, 28 Jan 2015 03:18:45 GMT

I agree with Jonas Heisterkamp. For incremental loads you will nearly always need a method to check if new data aren't already stored within the qvd (it's quite often that the workflow to fill the qvd isn't perfect ...). Also an optimized load from the qvd is extremly fast and shouldn't be a problem.

- Marcus

Re: Adding to QVD without loading it in

jagan — Wed, 28 Jan 2015 05:51:06 GMT

Hi,

Without loading the QVD it is not possible to append the data, instead you can create separate QVD each time you load.

Table:

LOAD

FROM TableName;

STORE Table INTO TableName_$(=Today()).qvd;

Now the script will create separate qvd everyday, not in script you can load all QVDs in a single shot by using wildcard characters

LOAD

FROM TableName_*.qvd (qvd);

Hope this helps you.

Regards,

Jagan.

Re: Adding to QVD without loading it in

Wed, 28 Jan 2015 19:47:51 GMT

We are planning on creating one QVD for each month in a calendar year, and appending the transaction data to that specific month. I was curious to know if it was possible to append to the month QVD without loading the whole one.

As mentioned by Marcus_Sommer, we can do a load from the QVD on the last available transaction date and compare it to the new data to be added. The last available transaction should give us less resulting rows than the whole QVD worth of data, which we can then append to.