Issues with incremental load

[Anonymous]

Hi

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?

[Anonymous]

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

[#3]

Hi,

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

[rubenmarin · Accepted solution]

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!

[Anonymous]

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