topic What is meant by partial reload? What is its use? Please explain! in QlikView

What is meant by partial reload? What is its use? Please explain!

Wed, 29 Feb 2012 18:43:35 GMT

Hi All,

What is meant by partial reload? What is its use? Please explain!

Thanks,

Attitude

What is meant by partial reload? What is its use? Please explain!

jagan — Thu, 01 Mar 2012 07:32:17 GMT

Hi,

Partial Reload is used whenever you just want to add some new data without reloading all other tables.

Suppose in your Qlikview file you have 10 tables which has millions of records, if you want one new table then you need to add the script, if you give normal reload it will reload all the 10 tables and the new table. Suppose if you don't want to reload the old 10 tables and just want to add new table then Partial Reload would be helpful.

This can done by using the ADD attribute to LOAD statement.

Table1:

------

Table2:

--------

Table10:

--------

Table11:

ADD LOAD * INLINE [

Key1, Value1

A, 100

B, 200

C, 100

];

Now if you use Partial reload, it just reloads the Table11.

Hope this helps you.

Regards,

Jagan.

What is meant by partial reload? What is its use? Please explain!

Thu, 01 Mar 2012 16:34:40 GMT

Thanks Jagan

That was very useful! Apart from using ADD I have also heard about REPLACE. Can it be used in the Partial Reload? If yes then please tell me how it can be used!

What is meant by partial reload? What is its use? Please explain!

jagan — Fri, 02 Mar 2012 06:06:52 GMT

Hi,

Replace will replace existing data in the table with new data. This also helps while using Partial Reload. For example

Table1:

------

Table2:

--------

Table10:

--------

Table11:

REPLACE LOAD * INLINE [

Key1, Value1

A, 100

B, 200

C, 100

];

When we use Partial Load for the above script, first 10 tables are not reloaded, Table11 is replaced with the new data. I think now you are clear about the REPLACE.

Regards,

Jagan.

What is meant by partial reload? What is its use? Please explain!

Tue, 13 Mar 2012 16:30:32 GMT

Thanks Jagan! That was really helpful!

So can we use only ADD and REPLACE attribute with partial reload? Please correct me if I am wrong...

Re: What is meant by partial reload? What is its use? Please explain!

IAMDV — Tue, 24 Apr 2012 06:21:49 GMT

Thanks Jagan. That was helpful.

At titude - I have created a video post on my blog covering Partial Reload. I hope that helps you as reference to what Jagan mentioned above. Here is the URL : http://qlikshare.com/370

Happy learning!

Cheers - DV

What is meant by partial reload? What is its use? Please explain!

Tue, 24 Apr 2012 15:38:33 GMT

Hi DV,

Thanks a ton! That was really useful.

Thanks,

Attitude

Re: What is meant by partial reload? What is its use? Please explain!

IAMDV — Tue, 24 Apr 2012 15:44:49 GMT

You are welcome mate!

I'm going to post Part - 2 in next 2 days. I'm trying to create atleast scenarios where Partial Reload solves the problem. So please stay tuned.

Cheers - DV

What is meant by partial reload? What is its use? Please explain!

Jason_Michaelides — Tue, 24 Apr 2012 16:18:26 GMT

Nice video, DV. I didn't know about that use of ONLY...

looking forward to part 2!

Jason

Re: What is meant by partial reload? What is its use? Please explain!

IAMDV — Sun, 29 Apr 2012 16:23:15 GMT

Hi Jason & At titude,

Here is the link for part 2. Sorry for the delay!

http://qlikshare.com/?p=377

Cheers - DV

Re: What is meant by partial reload? What is its use? Please explain!

shantanu73 — Tue, 05 Feb 2013 10:57:22 GMT

Hello Friends/Forum,

Due to some reason I can see the video.

But I want to clarrify/clear my understanding about Partial Reload. Following is me Understanding

We add the word “ADD” or ‘REPLACE is used in front of Sql statement/Load Statement.

Assuming that I had 2 tab TAB1 & TAB2

Explaintion:- In case of new record addition by add word ADD Here it will just add the record in Tab2

But in case of REPLACE it will drop the TAB2 and then put the record in TAB2. But it will Not change Tab1.

One more if, we add word ONLY after ADD or REPLACE then the ADD or REPLACE will be work only in case when Partial Reload is done from command line. And if we do normal reload from desktop then how it will behave?

I hope I had explain the scenraio.

My Question is Whether for Partial Reload we have to give the Command from Command Line or what ?

Thanks in Advance

Shantanu

Re: What is meant by partial reload? What is its use? Please explain!

shantanu73 — Tue, 05 Feb 2013 11:10:52 GMT

Hello Deepak Vadithala,

Due to some reason I can not see the video Partial Reload. If u don't mind can u please send me the PPT of Partial Reload

Thanks in Advance

Shantanu

Re: What is meant by partial reload? What is its use? Please explain!

Sat, 23 Mar 2013 13:04:35 GMT

Hey guys,

Using Exists in sql reload gives me this error ...SqlState: S1000, ErrorCode: 928, ErrorMsg: [Oracle][ODBC][Ora]ORA-00928: missing SELECT keyword

Removing Where clause works...

here's my other sql:

add ONLY SQL SELECT "DWH_CR_JOB",

"DWH_CR_LOAD_ID",

"DWH_ID",

"DWH_UP_JOB",

"DWH_UP_LOAD_ID",

"MART_INITIALLY_LOADED",

"MART_LAST_CHANGE_LOADED",

"DWH_CC_NODE_ID"

FROM CDW."DM_F_PVCA2"

WHERE NOT EXISTS (DWH_CC_NODE_ID)

Any idea?

Thanks

Madhu

Re: What is meant by partial reload? What is its use? Please explain!

Fri, 17 May 2013 17:51:17 GMT

Not Exists in this case appearts to need a subselect statement joined back to the root statement. Perhaps you're thinking of Not Null ? Check your SQL Statement in a native client.

Thanks;

Billy

Re: What is meant by partial reload? What is its use? Please explain!

Mon, 27 May 2013 17:44:20 GMT

Hey, i have a problem with this. I have some tables in my script that i've already reloaded. Now i want to add 2 tables more and only reload this 2 instead of all of them.

I put ADD LOAD * in both of them. And then i press CRL+SHIFT+R (partial reload) but it begins to load ALL the tables.. why is that? or what im i doing wrong?

Thanks u so much.

Licha

Re: What is meant by partial reload? What is its use? Please explain!

Wed, 23 Oct 2013 14:20:19 GMT

Hi Licha,

When you do the Partial Reload, make sure you are not in the script editor. This may solve your problem.

Patrick

Re: What is meant by partial reload? What is its use? Please explain!

Anonymous — Wed, 23 Oct 2013 15:15:46 GMT

Hi Attitude,

You can use ADD or REPLACE, and also the prefix only.

According to the qlikview reference Manual:

ADD:

Tab1:

load Name, Number from Persons.csv;

add load Name, Number from newPersons.csv;

During normal reload, data is loaded from Persons.csv and stored in the QlikView table Tab1. Data from

NewPersons.csv is then concatenated to the same QlikView table. See concatenated.

During partial reload, data is loaded from NewPersons.csv and appended to the QlikView table Tab1. No

check for duplicates is made.

Tab1:

select Name, Number from Persons.csv;

add load Name, Number from NewPersons.csv where not exists(Name);

A check for duplicates is made by means of looking if Name exists in the previously loaded table data (see

the function exists under exists(field [ , expression ]) (page 326)).

During normal reload, data is loaded from Persons.csv and stored in the QlikView table Tab1. Data from

NewPersons.csv is then concatenated to the same QlikView table.

During partial reload, data is loaded from NewPersons.csv which is appended to the QlikView table Tab1. A

check for duplicates is made by means of seeing if Name exists in the previously loaded table data.

Tab1:

load Name, Number from Persons.csv;

add only load Name, Number from NewPersons.csv where not exists(Name);

During normal reload, data is loaded from Persons.csv and stored in the QlikView table Tab1. The statement

loading NewPersons.csv is disregarded.

REPLACE:

Tab1:

Replace load * from File1.csv;

During both normal and partial reload, the QlikView table Tab1 is initially dropped. Thereafter new data is

loaded from File1.csv and stored in Tab1.

Tab1:

Replace only load * from File1.csv;

During normal reload, this statement is disregarded.

During partial reload, any QlikView table previously named Tab1 is initially dropped. Thereafter new data

is loaded from File1.csv and stored in Tab1.

Tab1:

Load a,b,c from File1.csv;

Replace load a,b,c from File2.csv;

During normal reload, the file File1.csv is first read into the QlikView table Tab1, but then immediately

dropped and replaced by new data loaded from File2.csv. All data from File1.csv is lost.

During partial reload, the entire QlikView table Tab1 is initially dropped. Thereafter it is replaced by new

data loaded from File2.csv.

Tab1:

Load a,b,c from File1.csv;

Replace only load a,b,c from File2.csv;

During normal reload, data is loaded from File1.csv and stored in the QlikView table Tab1. File2.csv is disregarded.

During partial reload, the entire QlikView table Tab1 is initially dropped. Thereafter it is replaced by new

data loaded from File2.csv. All data from File1.csv is lost.

Regards

Re: What is meant by partial reload? What is its use? Please explain!

Anonymous — Fri, 04 Jul 2014 12:03:26 GMT

Hi,

The following link for part 2 is broken :

http://qlikshare.com/?p=377

Please provide a new link for the same.

Thanks and Regards,

Geeta

Re: What is meant by partial reload? What is its use? Please explain!

Jason_Michaelides — Mon, 07 Jul 2014 07:41:20 GMT

http://qlikshare.com/377/

Re: Re: What is meant by partial reload? What is its use? Please explain!

IAMDV — Mon, 07 Jul 2014 09:26:18 GMT

Geeta - Use the below link.

http://qlikshare.com/?s=Partial+reload

Cheers,