Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Reply
Not applicable
Author

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);