LOAD INLINE

CarloRomagnano — Sat, 16 Nov 2024 17:34:18 GMT

In the script below, the variable v_file is not expanded only in the WHERE clause because of ";" after "my_filter=;".
If I change ";" with another char (e.g. my_filter=; -> my_filter=#) then v_file is expanded correctly.

P.S. If in the WHERE clause I add another condition (e.g. OR 1=1) the line is loaded else st_FileName = '$(v_file)' always is false.

Maybe it is a BUG?

LET v_file = 'abc';

SecTab:
LOAD *,'$(v_file)' AS A INLINE [
st_User,st_FileName,st_Filter
AD\ADELE,abc,my_filter=;
]
WHERE st_FileName = '$(v_file)'
;

Re: LOAD INLINE

MayilVahanan — Wed, 27 Jan 2021 01:09:25 GMT

HI @CarloRomagnano

May be, try like this

LET v_file = 'abc';

SecTab:
LOAD *,'$(v_file)' AS A INLINE [
st_User,st_FileName,st_Filter
AD\ADELE,abc,'my_filter=;'
]
WHERE st_FileName = '$(v_file)'
;

topic LOAD INLINE in QlikView

LOAD INLINE

Re: LOAD INLINE