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;
