Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

neha_potdar
New Contributor

Joining 2 tables

I have done following joins:

Temp1: LOAD id AS ID;

SQL SELECT id

FROM  "Temp1";

Temp2: LOAD  id_t AS ID ;

SQL SELECT id_t

FROM  "Temp2";

I cannot see 2 tables joined in the table viewer. I am expecting to see the 2 tables joined on ID in the table viewer which is not happening. Is there anything wrong in the code?

5 Replies
MVP
MVP

Re: Joining 2 tables

you see Temp1 table with ID field and all values

Temp2 has the same fields (ID) of Temp1 so  Qlik concatenates Temp2 data to Temp1 date (like a SQL union)

if you want 2 tables as in image add noconcatenate

Temp2:

noconcatenate

LOAD  id_t AS ID ;

SQL SELECT id_t

FROM  "Temp2";

1.png

danieloberbilli
Valued Contributor II

Re: Joining 2 tables

QlikView associates the tables by fields which share the same fieldname. There is no need to join them explicitly to get them connected as in SQL

neha_potdar
New Contributor

Re: Joining 2 tables

Okay. Thank you both for your quick reply. So there is no need to add "join" between the 2 tables right?

Re: Joining 2 tables

Hi,

If requires you can join this tables also

Temp1:

LOAD id AS ID;

SQL SELECT id

FROM  "Temp1";

Join(Temp1)

Temp2:

LOAD  id_t AS ID ;

SQL SELECT id_t

FROM  "Temp2";

Note:- Also check if one of the table has unique values.

Regards

Anand

neha_potdar
New Contributor

Re: Joining 2 tables

Thank you again. My doubt is solved.

Community Browser