Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Shahzad_Ahsan
Contributor II

How to merge two tables in data load editor

Hi Everyone

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

EmpIdEmp Name
1A
2B
3C

DocumentIdDocument
1D1
2D2
3D4
4D4

I need result like this

EmpIdDocumentId
11
12
13
14
21
22
23
24
31
32
33
34

Make sure I need it in data load editor only.

1 Solution

Accepted Solutions
silambarasan130
Contributor II

Re: How to merge two tables in data load editor

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

3 Replies
Shahzad_Ahsan
Contributor II

Re: How to merge two tables in data load editor

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

silambarasan130
Contributor II

Re: How to merge two tables in data load editor

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
Contributor II

Re: How to merge two tables in data load editor

Thank You Silambarasan

This is working

Actually I was trying Concatenate keyword

Any way thank you

Community Browser