Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik sense joins Question

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;

3 Replies
luismadriz
Specialist
Specialist

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

luismadriz
Specialist
Specialist

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

Anonymous
Not applicable
Author

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!.