Discussion Board for collaboration related to QlikView App Development.
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
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
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
Celambarasan,
It works like a charm..
Thanks a lot!