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;