Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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