topic Re: Load, Partial Reload in QlikView

Load, Partial Reload

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have 10 tables and after loading all the data (let say on January 2, 2016), I would like to load on a daily basis the 9 tables and quarterly basis the 10th table (let say April 1, 2016).

Though 10th table will be loaded quarterly, Qlikview should maintain the data of the 10th table which was loaded (in my example - January 2, 2016) initially until the next load (in my example - April 1, 2016)

Please advise how to do this.

Regards,

Obet

Re: Load, Partial Reload

sunny_talwar — Thu, 05 Jan 2017 11:59:57 GMT

Not entirely sure, but are you looking for Incremental load?

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

https://www.resultdata.com/three-types-of-qlikview-incremental-loads/

Re: Load, Partial Reload

Sun, 08 Jan 2017 05:47:45 GMT

Hi Sunny,

thanks for your reply.

I am not sure if it is incremental load:

I have 3 source table and after loading the data for the first time, I would like to update the two tables but not the 3rd table, though I would like to keep the 3rd table and the data that was previously loaded as this is part of the analysis.

I will give you an example:

Performance report happens only once a year, so there is no need to pull the data (which is by the way very large) via ODBC every time I click "load".

Regards

Re: Load, Partial Reload

girirajsinh — Sun, 08 Jan 2017 09:12:04 GMT

Hi Roberto,

I can think of two possible ways to do this. Of course there can be more ways too

Create separate QVD generator applications . One which should run and load the tables daily and 2nd QV document which is scheduled to runs quarterly.

Single QV document but you put the quarterly Load in a control statement (like if else ).

Use following function to check if today is the start of new quarter or not.. If yes then do tha load or else not.

You may then do incremental or completely REPLACE that load... I meant you can append data to (Today-April) loaded data Or you can remove it and load only (May - Aug)

QuarterStart(date[, period_no[, first_month_of_yea]])

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/quarterstart.htm

If you need to run on end of the quarter, you may use another function

QuarterEnd(date[, period_no[, first_month_of_year]])

But as I said there can be multiple ways to acheive this.

I hope this would help you.

Thanks

Giri