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';
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);
