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