What is the difference between SQL Select and QV Load statement?

[#1]

I am confused that what additional befenfit Load statement brings when we also have SQL statement in QV script?

It may seem stupid question, but I dont understand this, plesae help...

I may be misssing something very  basic.

Moreover when I select my SQL Server tables it also show me the SQL statment along LOAD. The only difference is that at the end of the Load statment, From Table Name is not displayed.

I dont know why table name is not displayed. What can I do to get rid of SQL statement and just keep the LOAD?

Thanks,

[jagan]

Hi,

SQL Select loads data from Database, where as QV Load statement loads from the Resident QV file.

When you SQL Server tables it also shows SQL statment along LOAD, if you don't to add/modify(Transform) the existing data then you can remove that Load statement above SQL SELECT.

If you want to transform your data i.e, add/update columns or data based on business logic then the LOAD statement is used.

For example:

Tablename:

LOAD

     *,

     Month(DateField) AS Month,

     Year(DateField) AS Year,

     QuarterName(DateField) AS Quarter;

SQL SELECT

     Customer,

     Product,

     DateField

FROM TableName;

In the above SQL statement you just have date field, for reporting we need addtional fields like Year, Month, Quarter etc., so by using the QV Load statement we arrive those fields.  This type of loading is called Precedent Load.

Hope this helps you.

Regards,

Jagan.

[klausskalts]

Also:nt will allow you to utilize all Qlik-functio

The Qlik Load statement will allow you to use all Qlik-functions (sparing you having to know all the different flavours of SQL-staments and functions).