topic how does this join work? in QlikView

how does this join work?

amien — Tue, 18 Aug 2009 19:25:28 GMT

i want all records from table1 .. and only 1 column (and one additional to match) of table2. but for some reason there are more records loaded in table 2 then there are in table1. The problem is that table2 is much longer then table1 and i cant load all the records of table2 .. waste of memory

if i use a LEFT JOIN in SQL i get all records from TABLE1 with ZIP6 on TABLE2.

Thanks in advanced

LOAD

FILENO,
TNR1,
TNR2,
TNR3,
TNR4,
SQL SELECT *
FROM TABLE1;

LEFT JOIN

LOAD

ZIP6,
FILENO;
SQL SELECT *
FROM TABLE2;

how does this join work?

Tue, 18 Aug 2009 19:31:09 GMT

I think Exists() can be of help here

how does this join work?

amien — Tue, 18 Aug 2009 20:01:11 GMT

something like this?

does this still work with left join?


LOAD
 FILENO,
 TNR1,
 TNR2,
 TNR3,
 TNR4,
SQL SELECT *
FROM TABLE1;

LEFT JOIN
LOAD

 ZIP6,
 FILENO;
SQL SELECT *
FROM TABLE2
WHERE EXISTS(FILENO);

how does this join work?

amien — Tue, 18 Aug 2009 20:13:07 GMT

QlikVIew functions like exists() are not supported in SQL statements - your database and your ODBC driver have no idea about QlikView functions.

how does this join work?

amien — Tue, 18 Aug 2009 23:44:24 GMT

fixed this with a normal JOIN ON SQL statement .. thanks for the EXISTS tip anyway .. didnt knew that one