topic Re: QVD files for incremental load using Insert, update and delete in QlikView

QVD files for incremental load using Insert, update and delete

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

Existing QVD -->Concatenate with--> DB data using incremental load (Insert, update and delete)

Final:

LOAD

Sales_date,

Type,

From Test.qvd(qvd);

Concatenate

LOAD

Sales_date,

Type,

FROM DB_TABLE;

STORE temp_Final into Test.qvd(qvd);

Re: QVD files for incremental load using Insert, update and delete

YoussefBelloum — Mon, 22 Jan 2018 12:44:28 GMT

Where is the question here ??

Re: QVD files for incremental load using Insert, update and delete

jonathandienst — Mon, 22 Jan 2018 12:52:12 GMT

To handle updates and deletes, you will need a unique identifier field and a last updated field (or something to determine if the line has changed since the last load, such as sequential ID numbers).

If you ask more specific questions, you will get more useful suggestions.