3 Replies Latest reply on Aug 31, 2016 3:58 AM by Mahfooj Khan

    Selecting value based on multiple conditions

    Sana Ali

      Hi ,

      Sorry for being naive but I can really use some help in sorting this problem . So I have data below and i want to get something like :

      If id has corresponding value of only a and c then select id , if it has corresponding value b too then dont select it .

      IdValueTime
      1a2016 - 10 -5 01:09:07
      1b2016 - 10 -5 01:09:08
      1c2016 - 10 -5 01:10:10
      2a2016 - 10 -6 04:10:11
      2c2016 - 10 -7 04:10:12
      3a2016 - 10 -5 01:09:07
      3b2016 - 10 -5 01:09:08
      3c2016 - 10 -5 01:09:09
      4a2016 - 10 -6 04:10:11
      4c2016 - 10 -6 04:11:11