topic Re: unmatched data in QlikView

unmatched data

prabhas277 — Thu, 16 Apr 2015 06:07:56 GMT

Hi experts,

i have 2 xl files please find the attached file and and share the how to get the unmatched data in front end

Re: unmatched data

prabhas277 — Thu, 16 Apr 2015 06:27:43 GMT

hi guys

please suggest this

Re: unmatched data

Ralf-Narfeldt — Thu, 16 Apr 2015 07:28:50 GMT

Here's a solution. Please mark as Answered if this suits your need.

Directory;

Source1:

LOAD pid as pid1,

pname as pname1,

pid&pname as pcon1

FROM

source..xlsx

(ooxml, embedded labels, table is Sheet1);

Directory;

Source2:

LOAD pid as pid2,

pname as pname2,

pid&pname as pcon2

FROM

source1.xlsx

(ooxml, embedded labels, table is Sheet1);

All:

Load pid1 as pid,

pname1 as pname,

pid1&pname1 as pcon

resident Source1;

concatenate load pid2 as pid,

pname2 as pname,

pid2&pname2 as pcon

resident Source2;

Matching:

Load pid as pid_m,

pname as pname_m

resident All where exists(pcon1,pcon) and exists(pcon2,pcon);

Unmatching:

Load pid as pid_u,

pname as pname_u

resident All where not exists(pid_m,pid);

Re: unmatched data

prabhas277 — Thu, 16 Apr 2015 08:04:26 GMT

Thanks for sharp reply

its very useful for me.and one more question

in the above i have two sources i.e source1 and source2.and each source having 3 sheets and total 6 sheets in 2 sources .now i want unmatched data regarding all sheets by using loop..

Re: unmatched data

Ralf-Narfeldt — Thu, 16 Apr 2015 08:36:10 GMT

This should help you with looping the Excel sheets:

Load Multiple excel sheets using For loop