topic Re: Innner Join to exclude values in other table in QlikView

Innner Join to exclude values in other table

Thu, 27 Nov 2014 16:15:00 GMT

Hi Experts

I have 2 Tables. One Field in a table contains a lot of data. Therefore, I would like to load only port of the data. Thus, I joined the tables to exclude part of the data:

Notiz:

SQL SELECT

notnr,

art,

thema,

notiz_typ,

txtnr

FROM EASY.notiz where notiz_typ = '258';

Inner Join (Notiz)

Text:

SQL SELECT

txtnr,

memofeld

FROM EASY.texte;

Problem is, "memofeld" is still loaded completely with 1 Mio datasets. The "Where" condition is ignored in this setting...

Thank you for your help!

Jan

Re: Innner Join to exclude values in other table

Anonymous — Thu, 27 Nov 2014 16:26:17 GMT

Try removing the Text: after the Inner Join (Notiz)

Re: Innner Join to exclude values in other table

anbu1984 — Fri, 28 Nov 2014 06:47:11 GMT

You can also join in sql

Text:

SQL SELECT

te.txtnr,

te.memofeld,

nz.notnr,

nz.art,

nz.thema,

nz.notiz_typ

FROM EASY.texte te, EASY.notiz nz

Where Trim(te.txtnr) = Trim(nz.txtnr) and nz.notiz_typ = 258;