Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

9 Replies
mdmukramali
Specialist III
Specialist III

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
Author

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

its taking all the existing Data from the old model

Itay

jagan
Luminary Alumni
Luminary Alumni

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
Author

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.

jagan
Luminary Alumni
Luminary Alumni

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
Author

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

jagan
Luminary Alumni
Luminary Alumni

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
Author

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
Author

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