Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Innner Join to exclude values in other table

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

Tags (1)
2 Replies

Re: Innner Join to exclude values in other table

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

anbu1984
Honored Contributor III

Re: Innner Join to exclude values in other table

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;

Community Browser