Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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);