Help

[Mahamed_Qlik]

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