Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Difference between SQL Select and LOAD

Hello everyone,

Is there a difference between using

SQL Select

....

From Table;

and

LOAD ... ;

SQL SELECT

...

FROM. Table ;



when extracting data from a database ?

1 Solution

Accepted Solutions
Not applicable

Re: Difference between SQL Select and LOAD

Select is actual what we are fetch data  from the database or from any other source.

You can not use any function when we are using

SQL Select

....

From Table;

If you want to use function to transform the data you need to use LOAD. ...;

2.........

load is always load column from preloaded table i.e. SELECT.

3............

you can use multiple load for one SELECT.

e.x.

load c1,c4 as c5,*;

load c1, c2 as c4;

select c1,c2,c3 from XXX;

1 Reply
Not applicable

Re: Difference between SQL Select and LOAD

Select is actual what we are fetch data  from the database or from any other source.

You can not use any function when we are using

SQL Select

....

From Table;

If you want to use function to transform the data you need to use LOAD. ...;

2.........

load is always load column from preloaded table i.e. SELECT.

3............

you can use multiple load for one SELECT.

e.x.

load c1,c4 as c5,*;

load c1, c2 as c4;

select c1,c2,c3 from XXX;

Community Browser