Issue with summing time using intervalmatch

villegasi03 — Wed, 26 Jun 2013 20:46:27 GMT

I am having an issue with summing minutes using intervalmatch. I am currently loading the following.

scheduleEvents:
LOAD id, starttime, stoptime, ActivityTypeName from events;

intervalTable:
LOAD minute, timeRangeName from MinuteSheet.xlsx;

LEFT JOIN (intervalTable)
INTERVALMATCH (minute) LOAD starttime, stoptime RESIDENT scheduleEvents;
LEFT JOIN (intervalTable) LOAD * RESIDENT scheduleEvents;
DROP TABLE scheduleEvents;

Once loaded I am able to group by timeRangeName and count the the minutes field to get total time for the interval. The issue that I am having is the amount of resources its using and the shear size of the application. I had to scale my load down to a week worth of data at one time for 100 employee events.

I really want to increase about of days I am loading but I am scared that my terminal would explode if I did so. Is there anything that anyone recommends that might help me out with my issue.

Thank you,

topic Issue with summing time using intervalmatch in QlikView

Issue with summing time using intervalmatch