topic Incremental Load without Primary Key in QlikView

Incremental Load without Primary Key

ShrutiChavre — Wed, 11 Dec 2019 08:38:48 GMT

Hi,

I am using a stored procedure to populate the QVD, and for incremental load I donot have any primary key in my data set. In my data set I have a column Flag, if Flag is 0 its new and 1 is Old. How can I implement this in my Qlik View Report so that Only those records come in the report with Flag 0. If the dataset records were updated to FLag = 1 then that record should not come in report.

Thanks.

Re: Incremental Load without Primary Key

michaelsikora — Thu, 12 Dec 2019 19:31:09 GMT

Hello!

You should be able to use a simple where clause to isolate the flag 0 records and concatenate these records to the table. For instance:

1) Load your QVD

2) Concatenate this table into the table above: Load the incremental data using where flag = 0

3) Reload into QVD

The reason you might want to create a primary key is if the table needs to make sure there are no duplicate records. Let me know if this works. If not, please share the code you are using.

Mike

Re: Incremental Load without Primary Key

Brett_Bleess — Wed, 18 Dec 2019 14:59:02 GMT

Did Michael's post get you what you needed for your use case? If so, please do not forget to return to your post and use the Accept as Solution button on his post to give him credit for the assistance and let other Community Members know that worked for you.

The only other thing I have is the following, not sure it will be of much help, but figured I would put it out here for others too:

https://community.qlik.com/t5/Qlik-Design-Blog/Overview-of-Qlik-Incremental-Loading/ba-p/1466780

Regards,
Brett

Re: Incremental Load without Primary Key

Marcos_rv — Wed, 18 Dec 2019 15:09:57 GMT

you have no way at least create a key concatenating fields ??? beyond having the flag, I would think of having a date at least to only bring the news, with the theme of the flag, if you know how old, you leave it in the QVD, I imagine that you are going to bring only those that the flag has in 0, this in the first instance would not be bad, but, the problem comes in that you can get to have a flag at 0 and add it to the model, and continue having it the next reload, so you would have repeated.

Cheers!!!