Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Section Access;
LOAD Distinct
USER_LOGIN
FROM
QVDS\SILK_USER_PROJECT_DW.qvd
(qvd);
SECURITY:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME
ADMIN, ALI, HIJAZI, *
];
Concatenate(SECURITY)
LOAD 'ADMIN' AS ACCESS,'*' AS USERID, '*' AS PASSWORD,'lb\' & USER_LOGIN AS NTNAME
Resident TEMP_SECURITY;
DROP Table TEMP_SECURITY;
Section Application;
I'm getting an error that says general script error
please advise
One error is here:
LOAD 'ADMIN' AS ACCESS
you do not need the single quote
Can you show the error?
I think QlikView simply cannot find the TEMP_SECURITY table because apparently you forgot to give the top table a name...
After Section Access; add this line:
TEMP_SECURITY:
NO i have to put this
it doesn't work either without single quotes
are u having/defined this table "TEMP_SECURITY"?