Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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!