Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can anyoine tell me what is the difference between the following two statements:
Script A
[Qlikview_A]:
Load
Column_1,
Column_2;
Sql
Select
Column_1,
Coilumn_2
from
Table1;
Script B
[Qlikview_B]:
Sql
Select
Column_1,
Coilumn_2
from
Table1;
Do you why we need to have a load statement in front of the SQL Statement?
Thanks!
Elim
AFAIK I don't think you do. Even with your Script B, you should see the same result as Script A.
This is called Preceding Load.
- Marcus
Hi Elim,
We can do some aggregations in load statement itself
for your reference
>>Can anyoine tell me what is the difference between the following two statements:
None whatsoever.
You only need a LOAD in front of the SQL SELECT (a preceeding load) if you need to apply some transformations using QV functions, or if you want to limit the number of fields you load from a stored proc (with SQL EXEC). Otherwise it is not necessary.
Got it!
Thanks for the input from everyone. Now I understand why we have to use the load statement b4 the SQL statment. I normally need not to use it unless I need to some transformations.
Thanks!
Elim