Q1 - How To Avoid Reload For Data Query Already Loaded

[#1]

Hi,

I have been practicing Qlikview and trying to understand basic data load. I am not sure if this is the right forum to question. But still I will go ahead with my doubt and I would be glad if you can redirect to concern team for help on this.

My Question:

1. I connect my database with ODBC connection

2. Select respective tables and column  (i.e I select 2 table in edit script)

3. I click reload to load the data from db to Qlikview. (total some 1 Millions records transferred)

Later I realize that i missed to add a table.

1. I go back to Edit Script

2. Add my missing table

3. Click on Reload - This process load back the table which was already loaded in above step.

(My question is why should i reload and spend time to load back same)

How can we avoid this ???

[sgrice]

you want to do Partial reload.

It's easy enough to setup has long has you do not used Concatenation or Joining.

[awhitfield]

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.

So... you could use this ...

[Gabriel]

Hi,

Another thing you can do is to add the word ADD before you new table, I mean the table you missed and only this table will be loaded.

Example:

Tab1:

load Name, Number from Persons.csv;

ADD load Name, Number from NewPersons.csv;

[#5]

Gabriel -

Thanks for the udpate but I am sorry this didnt not working. . I need to try with partial load and hope it works

[karthikeyan1504]

Hi Varun,

Please create a qvd for each table or block of code.

On top of that, based on time stamp of the qvd you can do the incremental load.

Thanks & Regards,

Karthikeyan.

[#7]

Can you please give me a sample code for this.

[#8]

Tab1: //Already Loaded into Memory

Load *;

SQL Load * From Tab1;

Tab2: //Already Loaded into Memory

Load *;

SQL Load * From Tab2;

Tab3:

Replace Only SQL Load * From Tab3;

To do partial reload, File -> Partial Reload (or) Ctrl+Shift+R

Regards,

KKR

[#9]

Member,

Thanks for these. I got this done. Appreciated