topic ask.. Load only new table in QlikView

ask.. Load only new table

Mon, 27 Sep 2010 03:02:10 GMT

hello all,

newbie need help .. 😄

thank you before,

i have a problem with qlikview loading,

every time i add a new table or edit my field,

i must reload whole things in edit script,

it is very wasting time..

can i only just load the new table or new field i just add in edit script?

is that called incremental load? and how to use it?

can you give me an example / code / syntax of it??

thank youu,

really need help here, urgent..

best regards !!

ask.. Load only new table

Oleg_Troyansky — Mon, 27 Sep 2010 05:05:50 GMT

WHat you are looking for is called "Partial Reload". During partial reload, only statements with prefix "ADD" or prefix "REPLACE" will get executed. So, if you need to add just one more table, you can add a prefic ADD in front of the LOAD statement, and then open Menu "File" - "Partial Reload".

However, if you change your load logic, you may or may not be able to use partial reload - depending on the magnitude of your changes.

I have to say - it's only good as a temporary measure. In the long run, you still want to have a full reload working. If you are developing your script andyou have a huge data set, you may want to create a parial data set for development purposes and only reload the full data set when your script is finished.

cheers,

ask.. Load only new table

Tue, 28 Sep 2010 10:14:00 GMT

thank you for your reply Mr.Oleg,

now i get what you mean,

but can you give me an example of the "ADD / REPLACE".

thank you so much

Best Regards !!

ask.. Load only new table

Tue, 28 Sep 2010 10:33:35 GMT

Hi,

For this you have the Partial Reload option in Qlikview.

1)if you want add new table in the existing Data Warehouse follow the below example syntax :

ADD Load * from Table1;

simple put "ADD" Function in front off Load

2)if you want change the Schema of Table or if you want to add one filed in existing schema follow the below syntax :

first drop the existing table with this syntax 'ADD DROP TABLE TABLE1'

ADD LOAD FIELD1 from TABLE1;