Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Delete records in Incremental Loading

I am trying to update and delete my records.....I am using two qvd files for updating.....Qvd1 has data till Nov 13th and qvd2 has till sysdate.....I loaded Qvd1 and created Maxdate and the loaded Qvd2 >Maxdate and Concatenated with QVD1.....So I got Updated Records......Now if any records are deleted in the database How should I write the code....I have some idea about that like using a primary key given by Rob.....But I am Not clear....Can anyone help me out in this.....

 

4 Replies
vgutkovsky
Honored Contributor II

Re: Delete records in Incremental Loading

There definitely has to be a key of some sort to allow you to identify each record, or else you would never even know that it was deleted. This may very well have to be a solution created by your DBAs--e.g. a stored procedure that would write a table of IDs of records that have been deleted in the last week. You would need to query this table when you reload. If you want to only use QlikView for the solution without bothering your DBAs, you would have to lose most of the benefits of incremental loading.

Regards,

Vlad

Not applicable

Re: Delete records in Incremental Loading

Dear ,

in Qlikview Help you will find a Procedure how to perform Incremental Load in detail.

i think that will help you.

Thanks,

Mukram.

Not applicable

Re: Delete records in Incremental Loading

I am having a primary key, but I am not sure how to use it in the code.....I have 2 QVDs how should I check with primary keys and delete the Recods.....If you dont mind can you be specific with code......Tnx.....

vgutkovsky
Honored Contributor II

Re: Delete records in Incremental Loading

Assuming that the DBAs provide a table of record IDs that have been deleted?