How to merge two tables in data load editor

[Shahzad_Ahsan]

Hi Everyone

I have 2 table Employee & Document. From two data sources. Employee is in SQL where as Document is in Excel

EmpId	Emp Name
1	A
2	B
3	C

DocumentId	Document
1	D1
2	D2
3	D4
4	D4

I need result like this

EmpId	DocumentId
1	1
1	2
1	3
1	4
2	1
2	2
2	3
2	4
3	1
3	2
3	3
3	4

Make sure I need it in data load editor only.

[Shahzad_Ahsan]

You can make changes in this

LIB CONNECT TO 'Employee';

LOAD EmpId,

    EmpName;

SQL SELECT EmpId,

    EmpName

FROM dbo.Employee;

LOAD

    DocumentId,

    Document

FROM [lib://Emp Doc/document.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Silambarasan1306 · Accepted solution]

Hi Shahzad,

We can get data any source. That is not a problem.

Simple, Outer join like below,

Load * Inline
[
DocumentId,Documemt
1,D1
2,D2
3,D4
4,D4
];

Join

Load * Inline
[
EmpId,EmpName
1,A
2,B
3,C
];

[Shahzad_Ahsan]

Thank You Silambarasan

This is working

Actually I was trying Concatenate keyword

Any way thank you