SQL statement Vs LOAD statement in Qlikview?

[nihhalmca]

Hi All,

Which one is better way to use (SQL and LOAD) while extracting data from data base

Can you explain breifly difference between SQL and Load

Thanks in Advance,

Nihhal.

[Gysbert_Wassenaar]

If you extract data from a database over odbc or oledb you must use the SQL keyword. The sql statement is sent to the database as-is. Qlikview does not and cannot parse sql statements. For all other sources, files, resident tables and preceding loads you use the LOAD keyword. Only in a LOAD statement can Qlikview functions be used. See this blog post for information about preceding loads.

[nihhalmca]

Hi Gysbert, Thank you for reply

I want to know the difference between SQL and LOAD. for instance if i extract data from datasourece thorugh this script what should be result

SQL empid

       ename

       loc

from emp;

And through this script what should be result

Load

      *

SQL empid

        ename

        loc

from emp;

Please let me know difference

Regards,

Nihhal.

[Gysbert_Wassenaar]

The first example could be a tiny bit faster since it doesn't use a preceding load. The end result is exactly the same since the preceding load in your second example doesn't do transformations or calculations.

[nihhalmca]

LOAD stmt is loading data into Qlikview from DB and SQL stmt also loading data from DB both are same as per you am i correct?

[#6]

SQL statement pulls the dat from DB , and LOAD statement works on top of that data , and performs operations that coded in load statement and stores the results in QlikView.

[jagan]

Hi Nihhal,

The Load statement on top of select statement is used to transform the retrieved data from database, it is not mandatory to use Load statement on top of select statement.  We will use when we are doing any calculations or arriving new fields like below

Load

      *,

Capitalize(ename) AS ename_Formatted,

     MonthName(date) AS MonthYear,

     Week(date) AS Week;

SQL empid

        ename

        loc,

date

from emp;

Here we are getting Month and week using Load statements, and converting the ename to title case. 

Hope this helps you.

Regards,

Jagan.

[agomes1971]

Hi,

Or are you referring Direct Discovery Differences between In-Memory Fields and Direct Discovery Fields with example.Thanks

HTH

André Gomes

[Anonymous]

Hi,

1.  Firstly SQL Statement is used to extract data from datasources and Saves into Qlikview memory. SQL SELECT Statement is executed by ODBC driver.

2.  Secondly use Load to save those records in QlikView(in memory), since QlikView will work with them without being connected to the datasource.

3. The Load Saves the extracted data from any DataSource(Ex: Inline Statement, SQL SELECT, Data Bases, CSV files, SAP queries, Excel files, Etc...) into QlikView in memory.

4.  LOAD is not mandatory, is highly recommendable. Actually, when you don't Use a LOAD statement, you can do an implicit load by just using SQL SELECT statement.

5.   LOAD is used to transformed or convert those records in a way how do you want them to be dealt, create new fields based on those you already have in your datasource, etc. which can be used in visualisation.

Check below Links:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load

http://community.qlik.com/message/259159#259159

http://community.qlik.com/message/29385#29385

http://community.qlik.com/thread/13682

http://community.qlik.com/message/156421#156421

Regards

Neetha

[nihhalmca]

SQL, LOAD both are extract data, STORE command only with store the data. Am i right?

My question is what is the diff b/w SQL and LOAD.