Intervalmatch Extended

Anonymous — Thu, 08 Dec 2016 11:31:46 GMT

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:

topic Intervalmatch Extended in QlikView