Load data without reload all data

[#1]

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

[brenner_martina]

Hi,

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

Add Load * From Table1;

or

Replace Load * from Table1;

[#3]

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

[suniljain]

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.

[#5]

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

[#6]

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

[#7]

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

:(((