Non Matching records with NOT EXIST

[Anonymous]

Hi Friends,

I am trying to pull non-matched records from below table1, & table2.

Expected o/p

Non_Matched

F1, F3

3,   C

Table1:

LOAD * INLINE [
F1, F2
1, A
5, E
6, F
];

Table2:
LOAD * INLINE [
F1, F3
1, A
3, C
6, F
];

Non_Matched:
LOAD
F1,
F3
Resident Table2
Where not Exists(Table1,F1);

But above script not producing any o/p, Can one of you let me Know how to compare table2 records with table1 and then pull only non-matched record of table2.

Thanks,

Ramesh.

[#2]

hi

try this

Table1:

LOAD * INLINE [

    F1, F2

    1, A

    5, E

    6, F

];

Table2:

LOAD * INLINE [

    F1, F3

    1, A

    3, C

    6, F

];

data1:

LOAD

F1 as F1_new,

F2 as F2_new

Resident Table1;

join

data2:

LOAD

F1 as F1_new,

F3 as F3_new

Resident Table2;

output:

LOAD

F1_new as F1_new1,

F3_new as F3_new1

Resident data1

Where F1_new=3;

DROP Table data1;