topic Re: incremental load and data reloading in QlikView

incremental load and data reloading

Mon, 05 Jan 2015 15:39:04 GMT

Hi All,

I have one field which contains years from 2010 to 2019, If it is current year then we should do incremental load otherwise it should do full load.But my Fiscal year start from October, If it is current year we should load last two months data. If October and November data are there in QVD then we should delete the current and previous month data (Dec & Jan) and again load the Dec & Jan and append to previous data (Incremental load).

Could you please help me on this with example?

Thanks,

M V

Re: incremental load and data reloading

Tue, 06 Jan 2015 04:05:32 GMT

Hi Guys,

Any ideas on this? Please help me on this.It's an urgent requirement.

Thanks,

M V

Re: incremental load and data reloading

jagan — Tue, 06 Jan 2015 05:09:09 GMT

Hi,

You need to create a Fiscal Calendar, check this file

Fiscal and Standard Calendar generation

Regards,

Jagan.