0 Replies Latest reply: Dec 8, 2016 6:31 AM by Marius Larsen RSS

    Intervalmatch Extended

    Marius Larsen

      I have a problem with the intervalmatch extended syntax,

      see attached file.


      it dosent get the tartildato correct when i connect both tables with an intervalmatch.

      seems like the problem is that it matches TARIFFRADATO with both LEVFRADATO and LEVTILDATO.


      Levfradato and levtildato is the datekey.



      inner join

      IntervalMatch (%DateKey, Kundekontrakt) LOAD TARIFFFRADATO,TARIFFTILDATO,Kundekontrakt,EKSTERNTRESEPTNAMN resident Produktbytte;




      Output in QV: