Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have scenario where I need to load only current month information every time the task runs.
For example, i have data for Jan , Feb and March(running). For Jan and Feb there won't be any changes in the sales but for March the numbers will keep on changing until the month is closed. How to perform the incremental load in this case.
Thanks for the suggestions.
Regards,
Viresh
Hi viresh
If records for current month Updated i.e. a rec shows 100 value yesterday, today can be changed to 80.
Then my suggestion is you should load all the data for latest month only by where condition;
where Month=max(Month) // also variable can be used to store max(month) data
also you can find docs for increment load here Incremental Load in Qlikview - Sources