Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
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.
Thank you, can we do this reload using windows task scheduler?
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.