Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
CarloRomagnano
Contributor
Contributor

LOAD INLINE

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)'
;

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

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)'
;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

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)'
;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.