Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
cansu
Contributor
Contributor

Section Access is not working for a user

Hello,

I've setup a section access for all the users based on username, it's not working only for a person. I've check the username in the directory. It looks same an works for other people. Only for one employee, this method is not working and we are trying to understand the reason. Our section access script is below:

Concatenate(SectionAccessTable)
LOAD
'USER' AS ACCESS,
'WSC\'&KEEPCHAR(UPPER(Left([FIRSTNAME],1)&[LASTNAME]),'ABCDEFGHIJKLMNOPQRSTUVWXYZ') AS USERID,
UPPER(Left([FIRSTNAME],1)&[LASTNAME]) AS EMPLOYEE
    ;
SELECT 
"FIRSTNAME",
"LASTNAME"
FROM "PK_DB"."TALEND_SCHEMA"."DIM_TECHNICIAN" WHERE ACTIVATED = 'T';
 
Section Application;

 

Labels (1)
1 Reply
marcus_sommer

Equally looking values mustn't be identically. I think I would check the length and each char from both sides. Maybe with something like:

load Field, len(Field) as Len, ord(mid(Field, iterno(), 1)) as CharNumber, mid(Field, iterno(), 1) as Char,
          iterno() as Iterno, rowno() as Rowno, recno() as RecNo
from Source while iterno() <= len(Field);