topic Re: Joining 2 tables in QlikView

Joining 2 tables

neha_potdar — Thu, 30 Oct 2014 20:27:23 GMT

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?

Re: Joining 2 tables

maxgro — Thu, 30 Oct 2014 21:45:34 GMT

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";

Re: Joining 2 tables

danieloberbilli — Thu, 30 Oct 2014 22:26:10 GMT

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

Re: Joining 2 tables

neha_potdar — Fri, 31 Oct 2014 16:05:42 GMT

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

its_anandrjs — Fri, 31 Oct 2014 16:47:12 GMT

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

Re: Joining 2 tables

neha_potdar — Fri, 31 Oct 2014 20:59:51 GMT

Thank you again. My doubt is solved.