topic why is this join not working? in QlikView

why is this join not working?

amien — Fri, 11 Sep 2009 22:37:59 GMT


ODBC CONNECT TO DB2;
LOAD FileNumber, Zone,
 Value;
SQL SELECT *
FROM BLA1;

LEFT JOIN

ODBC CONNECT TO DB2;
LOAD AccountNumber AS FileNumber,
 Contact,
 VoiceMail,
 Busy;
SQL SELECT *
FROM BLA2;

this should work .. but when i make a pivot table with Zone as dimension and a COUNT(FileNumber) as expression.. when i still have an empty zone with a count(FileNumber). Those Filenumber are the ones that are in BLA2 but not in BLA1 .. i only need all records from DB1 and the additional values of DB2 if match on Filenumber. in SQL LEFT JOIN should work .. but i dont know why this is not working

why is this join not working?

Oleg_Troyansky — Fri, 11 Sep 2009 22:46:17 GMT


Amien wrote:
ODBC CONNECT TO DB2;
LOAD FileNumber, Zone,
 Value;
SQL SELECT *
FROM BLA1;
ODBC CONNECT TO DB2;
LEFT JOIN
LOAD AccountNumber AS FileNumber,
 Contact,
 VoiceMail,
 Busy;
SQL SELECT *
FROM BLA2;

the code above should work - the ODBC CONNECT needs to precede Left Join. If it's connecting the the same database, it's even redundant. The rest of the syntax looks OK.

Oleg

why is this join not working?

Anonymous — Mon, 14 Sep 2009 01:04:56 GMT

If you're connecting to a different database, there should be the DISCONNECT statement before the second connect.
I never tried to skip DISCONNECT - may be it is not really necessary (?)

why is this join not working?

amien — Mon, 14 Sep 2009 13:21:57 GMT

perfect .. thanks al!

why is this join not working?

amien — Mon, 14 Sep 2009 14:04:36 GMT

according to the manual, the connection is automaticly disconnected when a new CONNECT job is executed