2 Replies Latest reply: Oct 21, 2016 3:40 PM by John Sumesh RSS

    Interval Match

    John Sumesh

      Table 1

          

      ProdcutIdPriceDateUnitSale
      11501/01/1456840
      22506/01/1525625
      34609/01/12261196
      44801/01/08783744

      Table 2

          

      ProductIdPrice_AltStart DateEnd Date
      11409/01/1304/01/14
      11501/01/1401/01/15
      11001/01/0901/01/10
      11612/01/1306/01/14
      22503/01/1512/01/15
      22206/01/1512/01/15
      22309/01/1512/01/15
      22001/01/0901/01/10
      34609/01/1212/01/12
      44801/01/0801/01/09
      44603/01/086/1/2008

      Output Table

          

      ProductIdPriceDateUnitSalePrice_Alt
      11501/01/145684014
      22506/01/152562523
      34609/01/1226119646
      44801/01/0878374448

       

      The Price_Alt value is the Min(Price_Alt) from Table 2 from the Date Period to which the Date field from Table1 belongs.

       

       

      Not able to get the same using Interval Match