unmatched data

[prabhas277]

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

[prabhas277]

hi guys

please suggest this

[Ralf-Narfeldt · Accepted solution]

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);

[prabhas277]

hi

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..

[Ralf-Narfeldt]

This should help you with looping the Excel sheets:

Load Multiple excel sheets using For loop