Discussion Board for collaboration on QlikView Scripting.
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!
Try removing the Text: after the Inner Join (Notiz)
You can also join in sql
FROM EASY.texte te, EASY.notiz nz
Where Trim(te.txtnr) = Trim(nz.txtnr) and nz.notiz_typ = 258;