Discussion board where members can get started with Qlik Sense.
I have 2 table Employee & Document. From two data sources. Employee is in SQL where as Document is in Excel
I need result like this
Make sure I need it in data load editor only.
Go to Solution.
We can get data any source. That is not a problem.
Simple, Outer join like below,
Load * Inline[DocumentId,Documemt1,D1 2,D2 3,D4 4,D4 ];
Load * Inline[EmpId,EmpName1,A 2,B 3,C ];
You can make changes in this
LIB CONNECT TO 'Employee';
SQL SELECT EmpId,
FROM [lib://Emp Doc/document.xlsx]
(ooxml, embedded labels, table is Sheet1);
Thank You Silambarasan
This is working
Actually I was trying Concatenate keyword
Any way thank you