18 Replies Latest reply: Mar 20, 2018 8:01 AM by Michael Anywar RSS

    Help with joining multiple tables while comparing dates (Date In)

    Michael Anywar

      Hello, Help with Join involving dates and multiple tables. I would like to Create a join of 3 tables linking them with the Product_ID. and using the date

       

      Produced

      Product_IDQuantityDateName
      P1342/1/2018PRO
      P247712/2/2018PRO2
      P286

      2/11/2017

      PRO2

       

      Ordered

      order idProduct_IDQuantityDateName
      id_1P111011/3/2018PRO
      id_2P2419/3/2018PRO2
      id_3P220

      2/11/2017

      PRO2

       

       

      StockLevel

      Product_IDQuantityDateName
      P1342/4/2018PRO
      P247712/3/2018PRO2
      P286

      11/1/2017

      PRO2

       

      Expected Table after Join.

       

      Join_Table:

      Product_ID;

      Quantity_Produced;

      Quantity_Sold;

      Quantity_Stock;

      Date


      The reason i need the date is because I would use it to filter/ create a dimension using it for Visualization. This date would also be used in the date Picker dimension. Thank you.