Where not exists()

[#1]

Hi Friends,

Can any body explain how qlikview identifying F1 is from tab1 from below code

tab1:

LOAD * INLINE [

    F1, F2

    A, 1

    B, 2

    C, 3

    D, 4

];

tab2:

LOAD * INLINE [

    F3, F4

    A, AA

    B, BB

    C, CC

    E, EE

];

qualify *;

Table3:

LOAD

    *

RESIDENT tab2

WHERE Not Exists(F1, F3);

[Colin-Albert]

QlikView references fields by name only.

In your case Table3 will contain data for F3 where F3 is A,B and C as these values exist in field F1, the table is irrelevant for the comparison. Row E is ignored as E does not exist in the F1 data.

[jmmayoral3 · Accepted solution]

I don´t understand your question very well.

Do you want to know how QlikView knows that F1 belongs to tab1?

QlikView doesn´t know that F1 belongs to Tab1.

QlikView knows that there is a field named F1 in the application. It doesn´t matter where the field is loaded. It could be loaded from one table or plus tables. In this case it would be a key field between tables and it has the aggregation of distinct values of those tables.

[manojkvrajan]

Pavan - QlikView script loads from top to bottom and left to right across the tabs. It automatically identifies the field (F1) based on the precedence. However, you just need to give the field name as the first argument in the EXISTS() function.