Display Uncommon Data fields between 2 tables.

[#1]

Hi I want to display uncommon data between 2 tables

EMP:

ID NAME

1     A

2     B

3     C

4     D

5     E

DEPT:

ID DEPT

4     IT

5     BPO

6     PHARMA

i want to display the intersection of data i.e

ID NAME

1     A

2     B

3     C

[#2]

Hi ,

Use not exists() function.

EMP:
LOAD ID,
     NAME
FROM
C:\Users\298458\Desktop\Test\Data\Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
DEPT:
NoConcatenate
LOAD ID,
     DEPT
FROM
C:\Users\298458\Desktop\Test\Data\Book1.xlsx
(ooxml, embedded labels, table is Sheet2);

c:
NoConcatenate
load ID as testid,
ID as EmpID,
NAME
Resident EMP;
join
load ID as testid,
ID as DEPTID,
DEPT
Resident DEPT;

drop Tables EMP,DEPT;

Final:
NoConcatenate
load * Resident c where not Exists(testid,DEPTID);
drop Tables c;

Thanks,

Sampath