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:





      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.