topic Re: SQL statement Vs LOAD statement in Qlikview? in QlikView

SQL statement Vs LOAD statement in Qlikview?

nihhalmca — Fri, 21 Jun 2013 14:06:36 GMT

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.

Re: SQL statement Vs LOAD statement in Qlikview?

Gysbert_Wassenaar — Fri, 21 Jun 2013 14:31:01 GMT

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.

Re: SQL statement Vs LOAD statement in Qlikview?

nihhalmca — Wed, 03 Jul 2013 12:26:43 GMT

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.

Re: SQL statement Vs LOAD statement in Qlikview?

Gysbert_Wassenaar — Wed, 03 Jul 2013 12:32:48 GMT

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.

Re: SQL statement Vs LOAD statement in Qlikview?

nihhalmca — Wed, 03 Jul 2013 12:48:31 GMT

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?

Re: SQL statement Vs LOAD statement in Qlikview?

Mon, 26 Jan 2015 06:49:23 GMT

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.

Re: SQL statement Vs LOAD statement in Qlikview?

jagan — Mon, 26 Jan 2015 09:54:17 GMT

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.

Re: SQL statement Vs LOAD statement in Qlikview?

agomes1971 — Mon, 26 Jan 2015 09:57:23 GMT

Hi,

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

HTH

André Gomes

Re: SQL statement Vs LOAD statement in Qlikview?

Anonymous — Mon, 26 Jan 2015 12:05:35 GMT

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