Do you why we need to have a load statement in front of the SQL Statement.

[#1]

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

[sunny_talwar]

AFAIK I don't think you do. Even with your Script B, you should see the same result as Script A.

[marcus_sommer · Accepted solution]

This is called Preceding Load.

- Marcus

[ramasaisaksoft]

Hi Elim,

We can do some aggregations in load statement itself

for your reference

What is preceding load in qlikview?

[jonathandienst]

>>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.

[#6]

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