Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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;