Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to qlik. I am trying to follow document and practice joins in qlik sense (In general I understand how joins work in DB).
Attached are the screenshots of qlik sense example and error.
I am loading data from excel as Table1 and Table2 then within Qlik sense i am trying to create another table called Vtable to store join result. Please let me know what i am doing wrong.
Table1 Data
A,B
1,aa
2,cc
3,ee
Table2 Data
A,C
1,xx
4,yy
Qlik Sense Script:
Table1:
LOAD
A,
"B"
FROM [lib://QS_Practice/Joins\Joins.xlsx]
(ooxml, embedded labels, table is Sheet1);
Table2:
LOAD
A,
C
FROM [lib://QS_Practice/Joins\Joins.xlsx]
(ooxml, embedded labels, table is Sheet2);
VTable:
load * from Table1;
inner join Load * from Table2;
Hi Ashok,
Please use the following:
VTable:
NoConcatenate
load * Resident Table1;
inner join Load * Resident Table2;
Drop Tables Table1,Table2;
I hope this helps,
Regards,
Luis
In order to use the Select statements as it says on the Tutorial, you need to open a connection and then refer to a table in that connection using the select statements.
If the tables have already been loaded in memory then you use resident to refer to them
Qlik will automatically concatenate tables that look the same and as Table1 and VTable look the same, you need to explicitly say not to concatenate.
The deletion of the tables at the end is for them not to link.
You should play with all these by placing those instructions as comments and see the difference,
I hope this helps,
Cheers,
Luis
Luis,
Thank you.i got it now. i think i was doing 2 things wrong.
1. i was trying as is without realizing example refereed to DB tables
2. I was using resident but Noconcatenate, Vtable wasn't created.
I knew all of this theoretically but i was n't able to do practical. Thank you for your help!.