topic Re: Q1 - How To Avoid Reload For Data Query Already Loaded in QlikView

Q1 - How To Avoid Reload For Data Query Already Loaded

Tue, 14 Jul 2015 14:39:48 GMT

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 ???

Re: Q1 - How To Avoid Reload For Data Query Already Loaded

sgrice — Tue, 14 Jul 2015 15:33:40 GMT

you want to do Partial reload.

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

Re: Q1 - How To Avoid Reload For Data Query Already Loaded

awhitfield — Tue, 14 Jul 2015 16:00:41 GMT

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 ...

Re: Q1 - How To Avoid Reload For Data Query Already Loaded

Gabriel — Tue, 14 Jul 2015 16:36:04 GMT

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;

Re: Q1 - How To Avoid Reload For Data Query Already Loaded

Wed, 15 Jul 2015 06:16:26 GMT

Gabriel -

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

Re: Q1 - How To Avoid Reload For Data Query Already Loaded

karthikeyan1504 — Wed, 15 Jul 2015 07:36:14 GMT

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.

Re: Q1 - How To Avoid Reload For Data Query Already Loaded

Thu, 16 Jul 2015 07:14:17 GMT

Can you please give me a sample code for this.

Re: Q1 - How To Avoid Reload For Data Query Already Loaded

Thu, 16 Jul 2015 07:41:02 GMT

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

Re: Q1 - How To Avoid Reload For Data Query Already Loaded

Thu, 16 Jul 2015 09:12:00 GMT

Member,

Thanks for these. I got this done. Appreciated