Reloading Data

[#1]

Good Afternoon,

I need some help with Reloading data for my daily reports.

I have a QlikView Document that contains tables with data from 2009 thru 2015. I need Reload only Current year (2015 tables). Is there a way that I can select only the tables that I want to reload? The Script is taking almost 2 hours to run because if is reloading all tables (2009 - 2015 tables).

Thank you for your input.

Claudia

[#2]

Can you use the Year in the where clause while you Load.

[MK_QSL · Accepted solution]

You can still load all data if necessary for your application point of view.. search Incremental Load and implement the same in your application.

But in case no need of all data, you can obviously use as what ramko496 said,, restrict the load as below

Load * From TableName where Year = Year(Today());

[maxgro]

split and save (in qvd) your data by year

load  onlyurrent year from db and other years from qvd

for incremental load you can read this post (look at Anand answer and atachments) or search in Qlik help (Using QVD file for incremental load)

Incremental Load