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

    Intervalmatch Extended

    Marius August 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.

       

      syntax:

      inner join

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

       

       

       

      Output in QV:

       

       

      TaptVunnettable:

       

       

      Produktbyttetable: