8 Replies Latest reply: Jan 28, 2015 8:39 AM by pavan Kumar RSS

    Where Exists() and resident load

    Robert Svebeck

      Hi

       

      Have these two tables:

       

      tab1:
      LOAD * INLINE [
          F1, F2
          A, 1
          B, 2
          C, 3
          D, 4
      ];

       

      tab2:
      LOAD * INLINE [
          F3, F4
          A, AA
          B, BB
          C, CC
          E, EE
      ];


      Now I want to know how to use Where not exists() and resident load to get a new table containing this data:

       

      F3,F4
      E,EE

       

       

      I know how to solve this by using mapping load, but I want to understand the Exists() function.

       

      Regards,

      Robert