Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mwscott1
Creator
Creator

How to concatenation data from two different tables

I need to concatenate User Name and Domain to be Email Address.

Table 1

User Name

Provider

Table 2

Provider

Domain

4 Replies
Nicole-Smith

Table1:

LOAD [User Name], [Provider]

FROM [Your Source];

LEFT JOIN (Table1)

LOAD [Provider], [Domain]

FROM [Your Source 2];

LEFT JOIN (Table1)

LOAD DISTINCT [User Name], [Domain], [User Name] & [Domain] as [Email Address]

RESIDENT Table1;

Clever_Anjos
Employee
Employee

Left join(Table 1) Load * Resident Table2;

Left join (Table 1) load *, [User Name]&'@'&Domain as [email] resident Table1;

Drop table Table2;

vishsaggi
Champion III
Champion III

Two tables will autojoin using Provider so just use a straight table and add

Dim: Provider

Expr: Name & Domain

Frank_Hartmann
Master II
Master II

try like this:

1:

LOAD [User Name],

     Provider

FROM

[227237.xlsx]

(ooxml, embedded labels, table is Tabelle1);

left join

LOAD Provider,

     Domain

FROM

[227237.xlsx]

(ooxml, embedded labels, table is Tabelle2);

2:

Load *,

[User Name]&'@'& Domain as emailadress Resident 1;

DROP Tables 1;