Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
"ID","USERNAME"
"001","robert"
and here the Code i use in the script
AccessTable:
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, admin, admin
];
AccessTable_tmp:
LOAD [ID] as [USER_KEY]
,'ADMIN' as ACCESS
,[USERNAME] as [USERID]
,[USERNAME] as [PASSWORD]
FROM
"..\InputData\ref_ter_users-Copy.csv"
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Concatenate(AccessTable)
load distinct ACCESS, USERID, PASSWORD resident AccessTable_tmp;
Section Access;
load ACCESS, USERID, PASSWORD resident AccessTable;
Section Application;
Anybody got a clue where my error is?
thanks
Robert
Try using uppercase for all field names and values on the Section Access, even for user names and IDs.
JG
Try using uppercase for all field names and values on the Section Access, even for user names and IDs.
JG
Thanks a lot for the fast reply. I almost thought that it was such a small thing.