Interval Match problem

Wed, 08 Jul 2009 18:51:54 GMT

Hi!

I've tried asking this question before but got no answer as yet. I've tried to make the problem more structured by an example. Maybe easier to look at for an outsider? I hope somebody has any suggestions!

The example below does in simple form what I want my code to do for larger tables: it links three tables based on a date from the first table which lies within a interval matched with the two other tables. It joins them all togethere to 1 table.

When I try this out on the real data, the code is crashing and giving: too low on virtual memory.

Any suggestions on how to work around this?

Thanks!!

Gjalt

DBC:
LOAD DBC,
Begindatum as BegindatumDBC,
wat
FROM
DATA.xlsx (ooxml, embedded labels, table is DBC);

EK:
LOAD DBC,
DeclaCode,
Begindatum as BegindatumEK,
Einddatum as EinddatumEK
FROM
DATA.xlsx (ooxml, embedded labels, table is EK);

right JOIN (DBC) IntervalMatch (BegindatumDBC) Load BegindatumEK, EinddatumEK RESIDENT EK;
right JOIN (DBC) LOAD DISTINCT * RESIDENT EK;
DROP TABLE EK;

Tarief:
LOAD DeclaCode,
Tarief,
Begindatum as BegindatumTarief,
Einddatum as EinddatumTarief
FROM
DATA.xlsx (ooxml, embedded labels, table is Tarief);

right JOIN (DBC) IntervalMatch (BegindatumDBC) Load BegindatumTarief, EinddatumTarief resident Tarief;
right JOIN (DBC) LOAD DISTINCT * RESIDENT Tarief;
DROP TABLE Tarief;

topic Interval Match problem in QlikView

Interval Match problem