Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Could you better explain your problem?
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;
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
I think the Farolito20 want to know how to transform a simple select in Database in Qlikview Statement. I created a script for him.
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)
LEFT OUTER JOIN not iexist in qlikview!
Just use LEFT JOIN
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.