topic Qlik Sense combine two columns in QlikView

Qlik Sense combine two columns

fatihu — Wed, 18 Jan 2023 14:33:31 GMT

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 — Wed, 18 Jan 2023 15:38:54 GMT

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 — Wed, 18 Jan 2023 16:19:11 GMT

first of all thank you

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

thanks