Intervalmatch Extended

[Anonymous]

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: