Help

Mahamed_Qlik — Wed, 25 May 2016 10:41:54 GMT

Hi All,

Below given is my section access script.Can anybody tell me what is wrong in that as the section access is not getting work:

SecurityTable:

LOAD ACCESS,

NTNAME,

UPPER(LEVEL1) AS LEVEL1,

UPPER(LEVEL2) AS LEVEL2,

UPPER(LEVEL3) AS LEVEL3,

'*' AS USERID,

'*' AS PASSWORD

FROM

[..\Include\TravelAnalyticATPI-SA.xlsx]

(ooxml, embedded labels, table is Sheet1);

Concatenate (SecurityTable)

LOAD * INLINE [

ACCESS, USERID, PASSWORD, NTNAME, LEVEL1, LEVEL2, LEVEL3

ADMIN, DEMO, ATP!123, *,

ADMIN, DEMO2, 123, *, *, *, *, *

USER, JOHN, 2222, *,

];

SECTION ACCESS;

NOCONCATENATE LOAD

ACCESS,

NTNAME,

USERID,

PASSWORD,

LEVEL1,

LEVEL2,

LEVEL3

RESIDENT SecurityTable;

SECTION APPLICATION;

DROP Table SecurityTable;

EXIT SCRIPT;

Regards,

Mahamed

topic Help in QlikView