4 Replies Latest reply on Feb 16, 2017 12:07 PM by Brian Cachuela

    Joining or Blending two tables that are designed differently

    Brian Cachuela

      This is my first post so let me know if there's additional info you need.

      I'm trying to create a visualization that will display both a list of primary and secondary products and the amount of sales for each.  Primary products are in one table and they are line by line.

       

      Table 1

      Main Prods

      Sale

      Prod1

      1

      Prod2

      1

      Prod1

      1

      Prod2

      1

      Prod1

      1

      Prod1

      1

      Prod2

      1

       

      Secondary products are in another table and have a collection size field that is summed.

      Table 2

      Sec Prods

      QTY

      ProdA

      129

      ProdB

      73

       

       

      Is there any way to have an end result like:

       

       

      Prods

      QTY

      Prod1

      4

      Prod2

      3

      ProdA

      129

      ProdB

      73

       

      Or

       

      Main Prods

      Sale

      Sec Prods

      QTY

      Prod1

      4

       

       

      Prod2

      3

       

       

       

       

      ProdA

      129

       

       

      ProdB

      73