Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Usage of LOAD....SQL SELECT Statement

Hi,

Could you please tell me the advantage of LOAD ... SQL SELECT and when we need to use this?

Is that we can use the QlikView functions in the LOAD and Database functions in the SQL SELECT part as
LOAD would manipulate in QlikView and SQL SELECT would manipulate in database
.? Is this correct.

Example:

LOAD floor(date(CREATION_TS)) as TS,
....

SQL SELECT MAX(CREATION_TS)
FROM sample.

The order of the LOAD and SQL SELECT can differ?correct?

10 Replies
Not applicable
Author

Good day

I use the Load … SQL in the following case ..

For example  cargo application has two tables and we want to link two filed with different names but with same content ..

               AWBN   and   AWBSEQ  

So the following can be used in the loading script

SQL

SELECT * FROM XXXX;

LOAD AWBN AS AWBSEQ ;

SQL

SELECT * FROM YYYY;

brgds

J.Saudi