Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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;