Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
evelien_morel
New Contributor

Left join issue

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:

QV AAA cost Left Join.png

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

Tags (2)
1 Solution

Accepted Solutions

Left join issue

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

View solution in original post

2 Replies

Left join issue

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

View solution in original post

evelien_morel
New Contributor

Left join issue

Celambarasan,

It works like a charm..

Thanks a lot!