pls look into this issue urgent?

[#1]

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 *;---- what is the use of qualify here 

Table3:

LOAD

    *

RESIDENT tab2

WHERE not  Exists(F1, F3); not exists means what here. full confused .pls clarify it

drop table tab1;

[MK_QSL]

Qualify will create the Table field like

Table3.F3

Table3.F4

When more than one fields are common in any table, QlikView will create a synthetic key.

Qualify is used to avoid the synthetic key.

[#3 · Accepted solution]

what not exist(f1,f3) give according to scenario

[MK_QSL]

Where Exists (F1, F3)

It will load only those values of F3 which are present in F1.

Where Not Exists (F1, F3)

It will load only those values of F3 which are not present in F1

[#5]

great

[MK_QSL]

Please close this thread by selecting CORRECT or HELPFUL answer.

Thanks

[#7]

but its not displaying sufficient result

[#8]

hi manish

i am getting same result for both exists and non exists

[MK_QSL]

Please check enclosed files.

(1) is for Not Exists

(2) is for Exists

If you think that this solves your problems, select my answer as CORRECT ANSWER...

Thanks

[Anonymous]

The Qualify statement is used for switching on the qualification of field names, i.e. field names will get the table name as a prefix.

see this post :Qualify using given keyword instead of table/source name