topic Re: Join Tables! HELP in QlikView

Join Tables! HELP

farolito20 — Thu, 31 Jan 2013 14:41:34 GMT

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)

Re: Join Tables! HELP

alexandros17 — Thu, 31 Jan 2013 14:44:25 GMT

Could you better explain your problem?

Re: Join Tables! HELP

Fri, 01 Feb 2013 12:58:24 GMT

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;

Re: Join Tables! HELP

Gabriel — Fri, 01 Feb 2013 14:56:33 GMT

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

Re: Join Tables! HELP

Fri, 01 Feb 2013 15:34:37 GMT

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

Re: Join Tables! HELP

srinivasa1 — Fri, 01 Feb 2013 15:53:48 GMT

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)

Re: Join Tables! HELP

farolito20 — Fri, 01 Feb 2013 17:18:40 GMT

LEFT OUTER JOIN not iexist in qlikview!

Re: Join Tables! HELP

Fri, 01 Feb 2013 17:25:30 GMT

Just use LEFT JOIN

Re: Join Tables! HELP

jagan — Sun, 03 Feb 2013 19:55:25 GMT

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.