Append new data from incremental load to QVD without opening old QVD

Thu, 05 Dec 2013 07:18:50 GMT

Dears,

I would wonder if there isn't any possibility in QliView to append new data to old QVD without a need to load the old QVD into memory, connect there new and old data and the save the new one table as QVD.

I'm an old ABAPer and I'm using this line to achieve the same from abap.

OPEN DATASET dataset_file FOR APPENDING IN TEXT MODE ENCODING NON-UNICODE.

This should save time while synchronizing tables SAP and QVD.

My scenario: there are several files greater > 1GB.QVD

each time new records should be appended, 1GB old data should be read concatenated with new records and then saved as 1,1GB.

Then open 1,1GB, concatenate new records and save 1,2 GB. ....

The target should be to append just rows into old qvd. Something like

BINARY OUT new_records(qvw) into x.QVD;

Thank you in advance for any hints.

Regards

Stan

Re: Append new data from incremental load to QVD without opening old QVD

Thu, 05 Dec 2013 08:41:57 GMT

of course, the greates option would be still to use "where exists ()" command in order to simulate a behavior of a table with primary key.

// is there any option to write an user dynamic library .dll for such a purposes?

open QVD in binary for appending mode where exists (%KEY_FIELD);

topic Append new data from incremental load to QVD without opening old QVD in QlikView

Append new data from incremental load to QVD without opening old QVD

Re: Append new data from incremental load to QVD without opening old QVD