1 Reply Latest reply: Oct 29, 2012 7:31 AM by Sampath Kumar RSS

    Display Uncommon Data fields between 2 tables.

      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

        • Re: Display Uncommon Data fields between 2 tables.
          Sampath Kumar

          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