topic not exists? in QlikView

not exists?

Anonymous — Wed, 15 Apr 2015 11:24:33 GMT

Hi,

i have 2 xl sheets loaded

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 ?

Re: not exists?

MK_QSL — Wed, 15 Apr 2015 11:26:52 GMT

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;

Re: not exists?

ali_hijazi — Wed, 15 Apr 2015 11:28:12 GMT

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

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

Re: not exists?

Anonymous — Wed, 15 Apr 2015 11:33:31 GMT

Not worked

Re: not exists?

ali_hijazi — Wed, 15 Apr 2015 11:40:33 GMT

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

Re: not exists?

Anonymous — Wed, 15 Apr 2015 12:16:43 GMT

No need yar i got it