Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

what's wrong with this script

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

I can walk on water when it freezes
5 Replies
robert_mika
Master III
Master III

One error is here:

LOAD 'ADMIN' AS ACCESS


you do not need the single quote

Not applicable

Can you show the error?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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:

ali_hijazi
Partner - Master II
Partner - Master II
Author

NO i have to put this

it doesn't work either without single quotes

I can walk on water when it freezes
buzzy996
Master II
Master II

are u having/defined this table "TEMP_SECURITY"?