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: 
farolito20
Contributor III
Contributor III

Join Tables! HELP

Help with or condition in join!

LOAD codCompania

FROM tableCompania A

LEFT OUTER JOIN tablaPartner B  (A.codCompania = B.codCompania or A.codActive=B.codActive)

8 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Could you better explain your problem?

Not applicable

Hi, try this script.

TMP_01:

LOAD *;

SQL

          codCompania AS codCompaniaA_A,

          codActive AS codActive_A

FROM tableCompania;

OUTER JOIN (COMPANIA_A)

LOAD *;

SQL

          codCompania AS codCompania_A,

          codActive AS codActive_B

FROM tablaPartner;

NOCONCATENATE

TMP_02:

LOAD *;

SQL

          codCompania AS codCompaniaA_A,

          codActive AS codActive_A

FROM tableCompania;

OUTER JOIN (COMPANIA_A)

LOAD *;

SQL

          codCompania AS codCompania_B,

          codActive AS codActive_A

FROM tablaPartner;

NOCONCATENATE

LOAD *

RESIDENT TMP_01;

CONCATENATE

LOAD *

RESIDENT TMP_02;

Gabriel
Partner - Specialist III
Partner - Specialist III

HI Eduardo,

Can you kindly explain to the community what you want to achieve. Your explanation with the script above will enhanced our understanding of the problem.

Regards,

Gabriel

Not applicable

I think the Farolito20 want to know how to transform a simple select in Database in Qlikview Statement. I created a script for him.

srinivasa1
Creator II
Creator II

Hi Do as below

LOAD codCompania

FROM tableCompania A

LEFT OUTER JOIN tablaPartner B  (A.codCompania = B.codCompania )

CONCATENATE

LOAD codCompania

FROM tableCompania A

LEFT OUTER JOIN tablaPartner B  A.codActive=B.codActive)

farolito20
Contributor III
Contributor III
Author

LEFT OUTER JOIN not iexist in qlikview!

Not applicable

Just use LEFT JOIN

jagan
Luminary Alumni
Luminary Alumni

Table1:

LOAD

     codCompania,

     codActive,

     '

     '

     '

     '

FROM tableCompania;

LEFT JOIN (Table1)

LOAD

     codCompania,

     codActive

     '

     '

     '

     '

tablaPartner;

Qlikview automatically joins the tables based on common columns in both tables.

Hope this helps you.

Regards,

Jagan.