2 Replies Latest reply on Mar 26, 2020 12:39 AM by Limei Liu

    filtering

    Chulaxshan Gunasegaram

      Hi experts,

      Norbert Maijoor

       

      I have to tables one is transaction table and another one customer details table. I need to merge two tables and filter out those customers' transactions only from the transaction table.

      but the transaction table has tow columns one is a sender other one is a receiver, so customers can be on either sender or receiver.

       

      ID
      Name
      number
      12assds22243
      24ddf23343

       

      Sender
      Receiver
      Type
      Date
      Amount
      222433452123/10/2019500
      532222243224/10/20191000

       

       

      Appreciate  if you could help to me

       

      Advance Thanks

        • 1. Re: filtering
          Shaji Mohamed

          Hi Chulaxshan,

          You can join the transaction table twice with customer table, first to retrieve sender id and second to retrieve receiver id.

          Once you've both ids, you can use ifnull formulae to add a condition to filter in/out the relevant customers

          • 2. Re: filtering
            Limei Liu

            Hello Chulaxshan

             

            I think you can duplicate customer data, and rename them to Sender and Receiver, and then join them with Transaction.

            When edit join condition, use "Edit join Calculation" to edit join condition

            Such as:

            number = if [Type] = 1 then [Sender1] end

            number = if [Type (receiver)] = 2 then [Receiver1] end

             

             

            I attached a workbook to show it. Please have a check.

             

            BR,

            Maggie