5 Replies Latest reply: Oct 3, 2016 9:55 AM by Sean Villacorte RSS

    Having issues on loading data in Section Access

    Sean Villacorte

      Hi Qlik,

      I'm currently using Qlik Sense 3.0. So I'm having issues on my script in the section access. I'm trying to access/load data from the qlik sense repository database.  No issues with it. But once  I load the data from a previously loaded table it locks my account. Here's my code:

       

      LIB CONNECT TO 'ABC';
      Users:
      NoConcatenate
      LOAD 'USER' as ACCESS, UserDirectory & '\' & UserId as USERID, NUM(Name) as NUMBER;
      Select "C"."Name", "A"."UserId", "A"."UserDirectory"
      From "TableA" "A"
      inner join "TableB" "B" on "A"."ID" = "B"."BUser_ID"
      inner join "TableC" "C" on "B"."B_ID" = "C"."ID";

      SECTION Access;
      NoConcatenate
      LOAD upper(ACCESS), USERID, num(NUMBER)
      Resident 'Users'; 

      Section Application;

      -----------------------------------------------------
      But if I store the data from the joined tables into a file and then on the section access I load the data where I store it from(text file), it works perfectly not sure why the code above locks my user account. I even tried converting the "NUMBER" column.


      Cheers,
      sv