10 Replies Latest reply: Oct 15, 2013 5:32 AM by Vishwaranjan Kumar RSS

    Non Matching records with NOT EXIST

    Jaswant Chowdary

      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.