Interval Match explodes

Fri, 03 Jul 2009 22:26:06 GMT

Hi There ( I tried this before, but the code at the bottom was poorly formatted, so here is the same post but with a better code-format),

I've got a problem with interval matching 2 tables, it keeps loading an unlimited amount of records when I run it. I'm trying to connect the table (DBC) to a table (EK) based on the following interval match:

If (BegindatumDBC) is in the interval (BegindatumEK-EinddatumEK) then connect the values (DBC)

I need to connect more values (through left joints) from that table but need to drop the EK table in the end to work around synthetic keys.... at least I think.

Still, when I run it, it keeps exploding in loading an unlimited number of records the second time it loads the (EK) table to match.

Can anybody help me out?

Thanks!!!



































DBC:


 
EK:


 
left




left join (DBC) load * Resident EK;
drop table EK; join IntervalMatch(BegindatumDBCnum) load BeginddatumEKnum, EinddatumEKnum resident EK;LOAD[DBC zonder ZV] as DBC, [DBC declaratiecode verzekerde zorg] as DeclaCode, Ingangsdatum,Afloopdatum,MAKEDATE(LEFT(Ingangsdatum,4),MID(Ingangsdatum,5, 2),RIGHT(Ingangsdatum,2)) as BegindatumEK,MAKEDATE(LEFT(Afloopdatum,4),MID(Afloopdatum,5, 2),RIGHT(Afloopdatum,2)) as EinddatumEK,num(MAKEDATE(LEFT(Ingangsdatum,4),MID(Ingangsdatum,5, 2),RIGHT(Ingangsdatum,2))) as BeginddatumEKnum,num(MAKEDATE(LEFT(Afloopdatum,4),MID(Afloopdatum,5, 2),RIGHT(Afloopdatum,2))) as EinddatumEKnumFROM (txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);LOAD Id,Begindatum,MAKEDATE(LEFT(Begindatum,4),MID(Begindatum,5, 2),RIGHT(Begindatum,2)) as BegindatumDBC,num(MAKEDATE(LEFT(Begindatum,4),MID(Begindatum,5, 2),RIGHT(Begindatum,2))) as BegindatumDBCnum,AGB &'.'& Zorgtype &'.'& Diagnose &'.'& Behandeling as DBCFROM[..\..\DBC analyse\DBCInvoerbestandmetDBCcode.csv] (txt, codepage is 1252, embedded labels, delimiter is ';', msq);
[\code]</body>

topic Interval Match explodes in QlikView

Interval Match explodes