Discussion Board for collaboration on QlikView Scripting.
I'm a beginner in QlikView.
One of my QlikView application taking couple of hours to load as the data is about past 2 years.
I wanna use Incremental load such that, first load will fetch all the records, and for the rest of the loads - it just brings the data which is newly loaded.
I do have a Date field.
For eg: I have all the data till 8/9/2015 and i wanna concatenate the data from 8/10/2015 to the existing data.
I was struggling to get the proper expression.
Can someone help here.
Load * from xyz.qvd .
Load * from xyz.qvd Where Date>=8/9/2015.
But i wanna load only values which were not present.
Go to Solution.
let vMaxTime = Peek('ModifyTime',-1,'Table');
DROP Table Table;
Where ModifyTime > $(vMaxTime);
Resident Details Order By ModifyTime asc;
DROP Table Details;
STORE * from Modified into Final.qvd(qvd);
This site has some good info on incremental load.
Load * from xyz.qvd
And Not Exists(FieldWithExistingValues);
See this post:
Thank you everyone.
Please select Correct Answer/Helpful as you got the solution. Thank you.
Sorry for the delay.