Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a requirement like, have to store data in QVD's by monthly with incremental load. How to achieve this?
Thanks,
Hi,
Check this
https://www.resultdata.com/qlikview-incremental-loads-and-qvds/
Data:
LOAD
*
FROM DataSource
WHERE MonthName(DateFieldName) = MonthName(Today());
LET vCurrentMonth = MonthName(Today());
STORE Data INTO [$(vCurrentMonth).qvd];
Like this create qvd for every month.
Regards,
Jagan.
Download the delta load (incremental load) template from Rob Wunderlich's QV cookbook site:
http://qlikviewcookbook.com/download/delta-load-template/
It does a very good job in explaining the principles of an incremental load (see the script section of the QVW).
Hope this helps,
Stefan
check this links for more information
http://www.learnqlickview.com/a-qlikview-qvd-function-to-simplify-incremental-data-load/
Hi,
Check this
https://www.resultdata.com/qlikview-incremental-loads-and-qvds/
Data:
LOAD
*
FROM DataSource
WHERE MonthName(DateFieldName) = MonthName(Today());
LET vCurrentMonth = MonthName(Today());
STORE Data INTO [$(vCurrentMonth).qvd];
Like this create qvd for every month.
Regards,
Jagan.