not exists?

[Anonymous]

Hi,

i have 2 xl sheets loaded

like

t1:

load field1

field2

from xl1;

t2:

load field1

field2

from xl2;

now i want find out unmatched data between these two  ?

i have used where not exists(f1) but it is giving table 2 data also with unmatched data

here my req is i want see only unmatced data between 2 xl sheets ?

[MK_QSL]

t1:

load field1

field2,

field1&'|'&field2 as key1

from xl1;

t2:

load field1

field2

from xl2

where not exists(key1,field1&'|'&field2);

Drop Field key1;

[ali_hijazi]

you need to have different field names in the 2 tables

or use no concatenate

as follows:

t1:

load f1, f2 from x1

t2:

noconatenate

load f1,f2 from x2

now you can use the not exits

or

t1:

load f1, f2 from x1

t2:

load f1 as F1,f2 as F2 from x2

t3:

noconcatenate

load * resident t2

where not exists(f1,F1)

but make sure to delete t1 to avoid auto concatenate by QlikView

[Anonymous]

Not worked

[ali_hijazi]

may you please send me sample excel sheets and I will send you the appropriate qv script?

[Anonymous]

No need yar i got it