topic Reload only one table instead of all tables in QlikView

Reload only one table instead of all tables

Tue, 08 Feb 2011 00:13:26 GMT

Hi everyone,

My application loads around 8 tables for every reload.

I need to do a one-off reload of only one table and not the rest of them.

I have to reload the exchange rate table which is the only thing that changed while the rest of the data has remained unchange.

Any idea??

Reload only one table instead of all tables

maneshkhottcpl — Tue, 08 Feb 2011 03:29:01 GMT

Hi,

U can use the partial reload option from the file Partial Reload option in menu, or use \r parameter from dos command.

please refer the attached application consisting the code for partial reload.

Good Luck

Reload only one table instead of all tables

Tue, 08 Feb 2011 03:57:19 GMT

Hi Manesh,

Thanks for the reply, but I am not sure of your code.

However I was successful in creating a partial load by writing a macro on the tab and adding

Add Load

FROM Table 12

However the data that changes in the new table does not appear in my application, while the unchange data does appear. I have no idea why

Reload only one table instead of all tables

maneshkhottcpl — Tue, 08 Feb 2011 04:05:38 GMT

Hi,

We have used this type of technique at many clients and its working fine.

First u have to remove the table which u are already have in ur application then using add u can add new table in ur application.

if table is already residue in ur application then new add table will not affect.

please send ur script if u can so i can give u some inputs.

Reload only one table instead of all tables

Tue, 08 Feb 2011 05:53:41 GMT

I did it but I had to empty the table that was still in the application, its really weird becaus I had to first use the "Replace Load" then remove the "Replace Load" function and put "Add Load".

The report seems to show correct numbers now but I dont understand what the Add reload and the Replace Reload actually do. And by the way, I tried UPDATE reload and pretty much did what Add reload does.

Any idea, and also thanks for your help

Reload only one table instead of all tables

maneshkhottcpl — Thu, 10 Feb 2011 09:58:06 GMT

please send me ur application.