Load only current month data

[vireshkolagimat]

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

[thevingo]

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