2 Replies Latest reply: Feb 5, 2013 5:26 PM by Robert Borer RSS

    Section access from CSV not working - user not found

      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