2 Replies Latest reply on Jun 21, 2018 8:58 AM by James D

    How to create a set of IDs that are in another Field?

    James D

      I have data as follows:

       

      transaction_idoriginal_transaction_idtransaction_type
      1234559712Sale
      9874512345

      Refund

       

      How do I create a set of transaction_id values that is IN when there is a matching value in the original_transaction_id tied to a Refund transaction_type?

       

      I am trying to keep only Sale transaction_type in the view, but identify ones that have a refund based on the transaction_id = original_transaction_id.