Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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

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

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