15 Replies Latest reply: Jun 8, 2015 9:41 AM by anbu cheliyan RSS

    Exclude a set of data if a specific record exists within the data

    Andrew Thomas


      I have the following set of data where an object number will have many different staus

       

       

      objectnoFormattedNumber1projectstatus
      PR0000658802.000409.01.01E0001
      PR0000658802.000409.01.01I0001
      PR0000658802.000409.01.01I0002
      PR0000658802.000409.01.01I0045
      PR0000658802.000409.01.01I0046
      PR0000658802.000409.01.01I0118

       

      Where the project status = I0046 I want to exclude all of the records applicable to the object number,if I0046 doesn't exist then I would want to display the records

       

      Can anyone help