Discussion board where members can get started with QlikView.
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
5) Load From Generated Data.
Recno() as Number,
Rand() as No
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.
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.
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 -
Year(Date) AS Year;
Hope this helps you.
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,
Please check the attachment using Symantic Load. I didn't found much about it.
You can also check Buffer, Info and Bundle loads.
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.
Adding one more in the list that is "Mapping Load". It would be great if someone can explain this as well.