Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

LEFT JOIN

Boa tarde!

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

3 Replies

Re: LEFT JOIN

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

Employee
Employee

Re: LEFT JOIN

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

Re: LEFT JOIN

Clever,

Muito obrigado!

Community Browser