Qlik Sense combine two columns

[fatihu]

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

[QFabian]

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;

[fatihu]

Hello @QFabian 

first of all thank you

how and where can I put the domain string 'JM' in the code?

thanks