topic Re: Exclude some tables when Reloading data in QlikView

Exclude some tables when Reloading data

Thu, 28 Apr 2016 18:12:50 GMT

Is there a way to exclude specific tables when reloading data, but keep the data that is not Reloaded?

for example, i have tables for each year of data going back 3 years. For years prior to current, the data will never change, yet every time we update current data, we have to reload the prior years.

possible to not reload, but keep the data?

thanks.

Re: Exclude some tables when Reloading data

trdandamudi — Thu, 28 Apr 2016 18:38:16 GMT

Do you look at Partial Reload ?

This command executes only Load and Select (SQL) statements preceded by a Replace or Add prefix. Other data tables remain unaffected by the command.

Re: Exclude some tables when Reloading data

rubenmarin — Thu, 28 Apr 2016 18:44:53 GMT

Hi Scott, maybe one of the link on this document can help you: Incremental Load in Qlikview - Sources

All about the same: using qvds to do a faster reload, optimized qvd reload can load millions of rows in few seconds.