5 Replies Latest reply: Jun 11, 2015 7:08 AM by Dirk Groen RSS

    Intervall match question

    Dirk Groen

      I have a fact table with dates, customers and other expressions

       

      Now i want to connect a table with fare prices

       

      This is a table with faire prices for every customer with a start and end date.

       

      for example :

       

      FarePrice:
      LOAD
            %PK_Abonnee as %PK_FareAbonnee,
             Date(StartDate,'DD-MM-YYYY') as StartDate,
             IF(isnull(EndDate)=-1,'31-12-2015',EndDate) as EndDate,
                [Fare price]
      FROM
      .......
      
      Facttable:
      Load
           %PK_FareAbonnee,
           %PK_Date
           #...
           #.....
      

      How can i connect this tables so i for every date and customer i can get the good fareprice

       

      Who can help me?

       

      Regards,

       

      Dirk