Discussion Board for collaboration on QlikView Scripting.
I tried to do the incremental load with the help of the document which is given in the below link.
But as per me it is not working . Requesting you to let me know what changes I need to do so that it works as expected.
Explanation about the problem given below:
I tried the incremental load application with the data of mine. I am facing few issues when I was trying with my data. It is not working as expected. Explained about the problem in the screen shot which is given below. Hope you can look into it and provide some solution for the same.
I have attached the document which I was trying with.
Thanks and Regards,
Pls Use Rob's QVW File for incremental load. It work fine. Because I tested that application on more than 15 crore of record of one table of SAP.
Many times I tried and failed to do the incremental load after referring to his document. So many them suggested his document and but I don't know why I am not able to do the same with the help of his document. If you are able to understand how it work using his document can you please do the required changes in my document?
Expecting a positive reply from you side!
I checked your application . It extracting full data from qvd for comparison with CSV.
and Increamental load check with full data of QVD because there is no limit on backdate updation. and It happening in my case when I developed increamental load application with SAP R/3.
One Solution is if your data is fixed for particular period then you can make seperate qvd for that. and compare key field for limited period only.
Primary key is there in my document. In the attached document of mine primary key is "dwrstkcode". To be frank I was not able to understand how it works so I never tried with his document.
If you are able to understand his document can you work with my data.
To avoid giving you the trouble I have myself did the required changes in the Rob' Incremental load document. This was the outcome once I loaded my data into this document.
I need your help there so that I can move further.
I Implemented Rob's Logic on your document. pls check attached File. If you any query pls reply me.
if you want to update data from specific date then
// QVD does not existLET INCREMENTAL_EXP = '';
// No QVD. Force full reload
//LET INCREMENTAL_EXP = 'WHERE ModDate >=' & MakeDate(2005,01,01); //?? Could also set it to some floor date
pls MakeDate(2005,01,01) Change Date here.
Is this 65,535 lines loaded from QVD? if so, this is expected as we have to load the data from QVD in order to perform the update.
Let me know, if this is loaded from DB.