topic Re: Selective Loading of data in QlikView

Selective Loading of data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Guys,

Assume if I have a Qlikview data model with two tables.

Is it possible to reload the data per day for one table and per week for another table?

i.e

Table1 - To reload once per day and

Table2 - To reload once per week (Both tables are in same QVW file).

Fri, 28 Jul 2017 12:58:32 GMT

Yes, You can do that with partial reload option. Please check the below script:

Weektable:

Load * from Weektable.qvd (qvd);

DayTable:

Load * from Daytable.qvd (qvd)

DayTable

Replace Only

Load * from Daytable.qvd (qvd);

Create two tasks in QMC, one task weekly regular reload. Another task daily with Partial reload option.

The partial reload only execute the 3rd Load statement and replace the data with previous one.

Anonymous — Fri, 28 Jul 2017 13:05:43 GMT

Thank you, can we do this reload using windows task scheduler?

Fri, 28 Jul 2017 13:44:18 GMT

Yes, you can create the batch file and use partial reload command. I don't have the command on top of my head. But you can Qlikview reference manual.