topic Re: Issues with incremental load in QlikView

Issues with incremental load

Anonymous — Tue, 24 May 2016 09:53:03 GMT

I had previously created a qvw file with data loaded from March 2015 till Feb 2015. A QVD file was created and this data was stored in it.

I had to include March month data so i did an incremental load by using concatenate and storing it back in qvd file.

Now I had to include April month's data so I again merely added the new file assuming to the qvd file using incremental load. I used the concatenate funtion and stored the data back into the qvd assuming it will April details in the QVD file.

The issue that I am facing is that it skips March and shows April 2016. Is it because when I created the initial load it had data till Feb 2016.

But in each incremental load I am saving the data back into the qvd file so it should contain March month and the new months that get added as and when I include it. Can anybody please help whats going wrong here?

Re: Issues with incremental load

Anonymous — Tue, 24 May 2016 09:56:47 GMT

Can you give the script which you've given for Incremental Load .

Re: Issues with incremental load

Tue, 24 May 2016 09:59:41 GMT

Hi,

Could you post your source code here to know better understanding of flow..

Re: Issues with incremental load

rubenmarin — Tue, 24 May 2016 10:30:46 GMT

Hi Sanjyot, without seeing the code I think in two possibilities:

- Some scheduled task is recreating the qvd, so the qvd returns to the original data when the task is executed.

- Something with the code, the logic adding data to a qvd is something like:

· Load qvd data.

· Concatenate new data in the same table (be sure than qv isn't giving any other name to the table)

· Store the table with the old and new data in the qvd (overwriting the qvd)

Hope this helps!

Re: Issues with incremental load

Anonymous — Wed, 25 May 2016 10:06:17 GMT

Thanks it worked. I was concatenating the qvd with the new file but i didnt over write the qvd with it.