Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
];
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);
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
];
Thank You Silambarasan
This is working
Actually I was trying Concatenate keyword
Any way thank you