Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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;
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
Not worked
may you please send me sample excel sheets and I will send you the appropriate qv script?
No need yar i got it