topic Re: How to concatenation data from two different tables in QlikView

How to concatenation data from two different tables

mwscott1 — Wed, 25 Nov 2020 16:16:04 GMT

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

Table 1

User Name

Provider

Table 2

Provider

Domain

Nicole-Smith — Fri, 29 Jul 2016 20:45:15 GMT

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 — Fri, 29 Jul 2016 20:46:20 GMT

Left join(Table 1) Load * Resident Table2;

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

Drop table Table2;

vishsaggi — Fri, 29 Jul 2016 20:48:33 GMT

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

Dim: Provider

Expr: Name & Domain

Frank_Hartmann — Fri, 29 Jul 2016 20:56:16 GMT

try like this:

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);

Load *,

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

DROP Tables 1;