4 Replies Latest reply: Feb 17, 2017 2:36 PM by Aar Kay RSS

    load only record with matched value

    Josh Chang

      Hello

       

      If I have a table

      IDProcessResult
      1234SMT1NG
      1234SMT1OK
      5645SMT2OK
      9235SMI1OK
      6224SMT2OK
      5645SMT1OK
      6224SMT1OO

       

      For a group of records with same ID and process, I want to keep only the record which has result= NG.

      For example in the above table, for ID =1234 and process=SMT1, there are two records with different result.

      I just want to keep the only record which ID=1234, process=SMT1 and result=NG.

      How can I do it?

       

      Thanks,

      Josh