7 Replies Latest reply: Oct 28, 2014 11:03 AM by Gysbert Wassenaar RSS

    Intervalmatch help needed



      I need to combine two tables into one to analyze actual demand vs shipped qty but I have not found a good way to do this yet.

      Hope somebody could help me with this.


      The challenge is that table for actual demand is aggregated by date (timestamp) while shipped qty is aggregated by period with a from - to timestamp.


      This shows the intended result:




      I have attached the qvd file for this simplified example.