9 Replies Latest reply: Jul 12, 2016 10:34 AM by Vineeth Pujari RSS

    Where not exists is not working?

    Prashanth Reddy

      Hi all,

       

      I am loading certain data which of yesterday's(I am getting data daily), and after loading today's data, I want to show the only records which are completely new in the output(No repetitions). I have used Where not exists to achieve the same, but it's not giving me the result of my expectation.

       

      For example:

      Yesterdays data:

      PO          Traveler Name          Policy              date

      12          Andy                        BookingMehtod  07/10/2016

      13          Allen                        BookingMethod  07/10/2016

       

      Today's Data:

      PO          Traveler Name          Policy              date

      15           Strauss                     Internal              07/11/2016

      13           Allen                          BookingMethod  07/11/2016

      16           Finch                        BookingMehtod  07/10/2016

       

      Expected result:

      PO          Traveler Name          Policy              date

      15           Strauss                     Internal              07/11/2016

      16           Finch                        BookingMehtod  07/10/2016


      thanks & regards

      Prashanth