Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LEFT JOIN

Boa tarde!

Preciso realizar um lookup entre duas tabelas distintas, como posso fazer?

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

1) with the left join as you said so :

     select field1, field2 from tab1;

     left join

     select field1, field3 from tab2;

2) with the lookup instruction

3) with the mapping instruction

Clever_Anjos
Employee
Employee

T1:

LOAD * FROM qv1.qvd(qvd);


LEFT JOIN

LOAD * FROM qv2.qvd(qvd);

Se as tabelas tiverem campos com o mesmo nome, serão esses a fazer a chave.

Caso não tenham será gerado um produto cartesiano.

Not applicable
Author

Clever,

Muito obrigado!