I have a section access script that is placed inside a text file [called Security.txt], which I am calling in the qlikview script using the Include statement.
$(Include=$(vpath)security.txt);
Inside the Security.txt, i have used an excel file where my actual user access is declared, the code looks like:
Section Access;
Load
UPPER(NTNAME),
UPPER(ACCESS),
UPPER(COUNTRY)
;
LOAD NTNAME,
ACCESS,
COUNTRY
FROM
(ooxml, embedded labels, table is Sheet1);
Section Application;
test:
LOAD * INLINE [
Data, COUNTRY
10, IN,
20, UK
30, AU
40, CH
50, US
60, SL
70, SG
80, OP
];
The section access doesn't seem to be working when I am calling an excel file within the txt file. But the same works if i define the user access within the txt itself and not through the XL file. Any idea how i can achieve this by still using xl file inside the txt ?
