topic Left join issue in QlikView

Left join issue

Anonymous — Mon, 27 Feb 2012 09:01:08 GMT

Hello,

As this is my first post here, I hope I have given enough information for you to understand the problem.

I'm trying to make a left join between 2 tables, but the left join doesn't appear to be "Left".

Here's the code:

ODBC CONNECT TO AAADTA ();

BKNF19:

Load *;

SQL SELECT *

FROM XXXXX.AAADTA.BKNF19

WHERE

BJKD19 = 2012

AND

BFKD19 = 'VIT'

AND

RKNR19 BETWEEN 600000 AND 799999;

LEFT JOIN (BKNF19)

LOAD RKNR06, RKNM06;

SQL SELECT *

FROM XXXXX.AAADTA.REKF06

WHERE RSKD06 = 'GRV';

And this is what i get after reload:

I would expect to see in column RKNR06 only 700200, as that is the number in column RKNR19.

Instead, I get everything from RKNR06.

What am I doing wrong?

Thanks a lot,

Evelien

Left join issue

CELAMBARASAN — Mon, 27 Feb 2012 09:42:16 GMT

Hi,

In qlikview to make a join it needs same field name,Check with this

ODBC CONNECT TO AAADTA ();

BKNF19:

Load *;

SQL SELECT *

FROM XXXXX.AAADTA.BKNF19

WHERE

BJKD19 = 2012

AND

BFKD19 = 'VIT'

AND

RKNR19 BETWEEN 600000 AND 799999;

LEFT JOIN (BKNF19)

LOAD RKNR06 AS RKNR19,RKNR06 , RKNM06;

SQL SELECT *

FROM XXXXX.AAADTA.REKF06

WHERE RSKD06 = 'GRV';

Hope it helps

Celambarasan

Left join issue

Anonymous — Mon, 27 Feb 2012 09:46:01 GMT

Celambarasan,

It works like a charm..

Thanks a lot!