3 Replies Latest reply: Feb 15, 2017 8:54 AM by Sunny Talwar RSS

    Join/Merge/Concatenate two tables

    Aviad Bein

      Hi all,

       

      I've got two tables, "Parent Customer and "Child Customer", like this:

       

      Parent Customer:

      CustomerRevenue
      Customer A100
      Customer B50
      Customer C20
      Customer D10

       

      Child Customer:

      CustomerCustomerChildChildShare
      Customer ACustomer A10.2
      Customer ACustomer A20.3
      Customer ACustomer A30.5
      Customer BCustomer B10.9
      Customer BCustomer B20.1

       

      and I want to merge them like this:

      CustomerRevenue
      Customer A1100*0.2
      Customer A2100*0.3
      Customer A3100*0.5
      Customer B150*0.9
      Customer B250*0.1
      Customer C20
      Customer D10

       

      any ideas?

       

      Thanks in advance,

      Aviad