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: 
Anonymous
Not applicable

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

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

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
CELAMBARASAN
Partner - Champion
Partner - Champion

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

Anonymous
Not applicable
Author

Celambarasan,

It works like a charm..

Thanks a lot!