topic Load data without reload all data in QlikView

Load data without reload all data

Wed, 27 Apr 2011 10:43:27 GMT

Is possible to load information into a document without having to load all the information previously uploaded?

I mean,

In a document I have monthly data for 2009, 2010 and 2011 and I want to add "March". It would be possible to add the new month without having to reload all the information?

Thanks

AW:Load data without reload all data

brenner_martina — Wed, 27 Apr 2011 10:49:40 GMT

Hi,

of course, therefor is the menu Partial Reload, you have to enter Add or Replace before loading a table:

Add Load * From Table1;

Replace Load * from Table1;

Load data without reload all data

Wed, 27 Apr 2011 10:50:06 GMT

Yes it is possible, you can do it both ways (at least)

1. use partial reload will load only table preceded by

ADD LOAD (or REPLACE LOAD) if you want concatenate or replace

use exactly the same structure into the same table

EX:

Tab1:

load all your fields from Logfiles

Tab1:

ADD LOAD all your fields from LastFile

using instruction partial reload will load onlyLastfile into table Tab1 added to first Tab1

2. the second way is to use QVD files when loading and check the part you want to load using test or exists or another restriction criteria.

best regards

christian

Load data without reload all data

suniljain — Wed, 27 Apr 2011 11:10:43 GMT

dear Christian,

Add Load also load all data during load.

pls check it.

There is no such a method to add incremental data without reloading all historical data.

Load data without reload all data

Wed, 27 Apr 2011 14:04:17 GMT

Namaste Sunil,

it seems you're right. I made a test and the REPLACE had been executed with a normal load and not with the partial reload. This is quite strange according to the Qlikviex help

Partial Reload

This command executes only load and select statements preceded by a replace or add prefix. Other data tables remain unaffected by the command

best regards

christian

Load data without reload all data

Thu, 28 Apr 2011 15:51:48 GMT

HOPECOVE, can you explain better the 2 nd way?

I think the first option does not helps me. I want to add new values from the same table. I have loaded: JAN/09, FEB/09, MAR/09, ..., JAN/10, FEB/10, ..., now I want to add APR/11, then MAY/11, ...

Thanks to all

Load data without reload all data

Thu, 28 Apr 2011 16:01:13 GMT

Sorry, I just saw the last sentence of Sunil, which says that its not possible to add new data without loading all the data ...

:(((