join understanding doudt

[varunvarma]

Hi all,

I have small doudt in joins. Eg :- Please look below picture.

In 1 case EMPID is the key, what is the key in 2 case ? please clarify. Thank you.

[ashfaq_haseeb]

Hi,

EMPNA for second .

Check this for more clarification on how join works in Qlik.

http://community.qlik.com/docs/DOC-6562

http://community.qlik.com/thread/39177

http://community.qlik.com/thread/134760

Regards

ASHFAQ

[marcus_malinow]

In the second example, EMPNA is the key being used for the JOIN as it is your only common field.

[varunvarma]

Hi,

Thanks for the reply. If alias name are there then how it will treat the keys. i.e actual names or alias names or both ?

[Anonymous]

Hi  Varun

The 1st condition is trying to join based on EMPID field while 2nd condition is trying to join based on the name field (EMPNA)

-Jay

[ashfaq_haseeb · Accepted solution]

Alias name.

Regards

ASHFAQ

[its_anandrjs]

Hi,

In the first join is based on EMPID and in second it is based on EMPNA and you can use both also

Like

Load EMPID,EMPN as EMPNA,SAL from table1;

Left join

Load EMPID,EMPNA,SALA from table2;

Regards

Anand

[varunvarma]

Hi Ashfaq,

Please look at below picture.

In 2nd case left join, what is key ???. Please clarify me. Thank you.

[ashfaq_haseeb]

Hi

It will join on both fields

Regards

ASHFAQ

[varunvarma]

Thank you so much