Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How many types of load available in qlikview?Name and explain about them.

Hi All,

How many types of load available in qlikview?Name and explain about them.

Thanks,

Attitude

Tags (2)
9 Replies
mdmukramali
Valued Contributor III

How many types of load available in qlikview?Name and explain about them.

Dear,

The Load Statement load the Data into Qlikview  from different sources  by different methods.

Data that can be loaded into Qlikview:

1)   Load  Data from  Database.

       load * from sql statment:......................;

2)   Load Directly from text,excel,Qvd,xml files.

Load * from c:\.............................

3)  Load from previously loaded Table(Resident)

          Load * from Resident table1;

4)  Load directly by using Load Inline

Load * inline

[

Country,Sales

IND,2000

Aus,1500

];

5)  Load From Generated Data.

Load

Recno() as Number,

Rand() as No

AutoGenerate(10);

Thanks,

Mukram.

Not applicable

Re: How many types of load available in qlikview?Name and explain about them.

Binary Load from other model.
Binary c:/,,,,,sales.qvw;

its taking all the existing Data from the old model

Itay

MVP & Luminary
MVP & Luminary

How many types of load available in qlikview?Name and explain about them.

Hi,

I think you are asking about the types of load not load/statement.

There are different methods of loading the data.  They are

1) Full Reload - Reloads all the data in the tables

2) Partial Reload - Loading only new data (Refer http://community.qlik.com/thread/48344?tstart=0)

3) Incremental Reload - Loads new data only, instead of reloading all the data.  You can find this concepts in Qlikview help file.

Hope this helps you.

Regards,

Jagan.

Not applicable

How many types of load available in qlikview?Name and explain about them.

Thanks Jagan! I am also not sure whether this is the answer for this question. But personally feel that answer that you have given is the right one and I also thought of the same.

MVP & Luminary
MVP & Luminary

How many types of load available in qlikview?Name and explain about them.

Hi,

I am not sure what you are expecting for Types of Load.  May be the below details helps you

Resident Load - Loads the data from already loaded table in qlikview.

Binary Load - Loads data from another Qlikview file.

Precedent Load -

     Ex:

     LOAD

     *,

     Year(Date) AS Year;

     LOAD

         *

     FROM Datasource;

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: How many types of load available in qlikview?Name and explain about them.

Hi Jagan,

Apart from Full reload, Partial reload and incremental reload. There is one more reload which I have heard is "Semantic Load". Can some one please explain me about Semantic Load with example?

Also requesting you to let me know is there is any other load which we have missed out in this forum?

Thanks and Regards,

Attitude

MVP & Luminary
MVP & Luminary

Re: How many types of load available in qlikview?Name and explain about them.

Hi,

Please check the attachment using Symantic Load.  I didn't found much about it. 

You can also check Buffer, Info and Bundle loads.

Regards,

Jagan.

Not applicable

Re: How many types of load available in qlikview?Name and explain about them.

Hi Jagan

We have left out one more load in this post that is "Hierarchy Load ".

Can some one please give me explanation on Semantic load, Buffer load, Bundle load and  hierarchy load? It will be helpful for everyone who are following up this post.

Thanks,

Attitude

Not applicable

Re: How many types of load available in qlikview?Name and explain about them.

Hi All,

Adding one more in the list that is "Mapping Load". It would be great if someone can explain this as well.

Thanks,

Attitude