Discussion Board for collaboration related to QlikView Deployment.
Hello, the section access of Qlikview is driving me crazy.
I am loading data from a CSV file but when i try to enter the user it is not recognized.
Meaning I am prompted for a Username and when i enter admin, it asks me for a user name again.
Here the CSV LAYOUT I use
and here the Code i use in the script
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, admin, admin
LOAD [ID] as [USER_KEY]
,'ADMIN' as ACCESS
,[USERNAME] as [USERID]
,[USERNAME] as [PASSWORD]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
load distinct ACCESS, USERID, PASSWORD resident AccessTable_tmp;
load ACCESS, USERID, PASSWORD resident AccessTable;
Anybody got a clue where my error is?
Go to Solution.
Try using uppercase for all field names and values on the Section Access, even for user names and IDs.
Thanks a lot for the fast reply. I almost thought that it was such a small thing.