Left Join doesn't work. Mistake or too much data?

Wed, 18 Sep 2013 19:48:36 GMT

Hello everybody! (again )

QlikView crashes (Failure in script load dialog) doing this:

Item:
LOAD
"No_" as "Item No",

"Item Type",

...other fields;
SQL SELECT
"No_",

"Item Type",
...other fields
FROM xxx;

ItemEntries:
LOAD

"Item No_" as "Item No",

...other fields;

SQL SELECT
"Item No_",
...other fields
FROM ...xxx;

Let vFirstDate = Num('01.01.2011');
Let vLastDate = Num('31.08.2013);

For i = $(vFirstDate) To $(vLastDate)
ItemByMasterDate:
LOAD "Item No",
Date($(i)) as MasterDate
Resident Item;
Next i;

Left Join (ItemByMasterDate)
LOAD *
Resident ItemEntries;

DROP Table ItemEntries; //no synth. keys

Is there something wrong or are over 3 Million Entries in ItemEntries for this loads of MasterDates really too much, even for a big server?

I'm trying to do this: Sum up until dimension value . In my "old" solution it lasts some minutes... Therefore I'd like to use a Flag like tresesco suggested.

Or does someone has a idea for a good performance?

Thank you very much! (and also for your past answers and ideas)

Best regards,

Andreas

PS: Tried to replace the Resident with direct load... didn't help...

topic Left Join doesn't work. Mistake or too much data? in QlikView

Left Join doesn't work. Mistake or too much data?