Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

QVD files for incremental load using Insert, update and delete

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

Final:

LOAD

Sales_date,

Type,

ID

From Test.qvd(qvd);

Concatenate

LOAD

Sales_date,

Type,

ID

FROM DB_TABLE;

STORE temp_Final into Test.qvd(qvd);

2 Replies
Highlighted
Champion
Champion

Where is the question here ??

Highlighted

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein