How to concatenation data from two different tables

[mwscott1]

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

Table 1

User Name

Provider

Table 2

Provider

Domain

[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]

Left join(Table 1) Load * Resident Table2;

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

Drop table Table2;

[vishsaggi]

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

Dim: Provider

Expr: Name & Domain

[Frank_Hartmann]

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;