Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
i have the section access code, where i load user data from a database, like:
section access;
load
upper(USERID) as USERID,
ACCESS;
SQL SELECT ..... (SQL code here)
this ends in a table like:
USERID, ACCESS
user1, admin
user2, user
now i want to add to each user in the section access table a certain String (domain), like:
'COMPANY\'
the resulting section access table should look like:
USERID, ACCESS
COMPANY\user1, admin
COMPANY\user2, user
how can i do this? i can not "hard code" it, because the table is automatically loaded from the SQL code and the user data is not defined in qlik.
Can someone help me please?
Thank you very much!
Best regards
Hi @fatihu , please check if something like this is what are you looking for :
Aux:
load
upper(USERID) as USER,
ACCESS;
SQL SELECT ..... (SQL code here);
Left join
Domain:
Load
USERFIELD as USER,
DOMAINFIELD as DOMAIN
From SQLSOURCE;
Section access;
SECTIONACCESS:
Load
DOMAIN & '\' & USER as USERID,
ACCESS
Resident Aux;
drop table Aux;
Hello @QFabian
first of all thank you
how and where can I put the domain string 'JM' in the code?
thanks