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: