Time Series Help - 1.68 Million cells!!

Hi,

 

Given Below is a sample time series (total cell value of date set is 1.68 Million Cells) :

    A1 A2
Date Time Buy Sell Buy Sell
1/4/2012 00:00 - 00:15 5.5 10.7 11.1 11.5
1/4/2012 00:15 - 00:30 5.5 10.7 11.1 11.5
1/4/2012 00:30 - 00:45 5.5 10.7 11.1 11.5
1/4/2012 00:45 - 01:00 5.5 10.7 11.1 11.5
1/4/2012 01:00 - 01:15 5.5 7.7 11.1 11.5
1/4/2012 01:15 - 01:30 5.5 7.7 11.1 11.5
1/4/2012 01:30 - 01:45 5.5 7.7 11.1 11.5
1/4/2012 01:45 - 02:00 5.5 7.7 11.1 11.5
1/4/2012 02:00 - 02:15 5.5 7.7 11.1 81.5

The entire time series is:

1. Daily Data from April 2012 Onwards

2. Each day has 96 rows one row for each 15 Minute time block (96 Rows mer month)

3. There are 8 regions and buy and sell volume is separately given for each region (16 Columns)

Problem 1: I have two row headers date and time. Now each date is repeated 96 times for each time block

Problem 2: I have to column headers "Region" and Buy & Sell

 

 

Help Needed: How do I import this data and look at in three different ways:

1. By time block (example aggregate demand and supply for all days for the time block 00:00 - 00:15)

2. My Month (example aggregate buy and sell volumes for all April (2012+2013+2014+2015)

3. By Region (example aggregate buy and sell volumes for region A1)

Sample sheet for one month is attached

 

 

Hi

this is a job for the group by node :-)

For Job 1: use the group by on the time column and aggregate on demand and supply

For Job 2: You first need to split the date Time column with the string splitter. Than you can use the groupby node again.

 

The data size of course does need memory and time. But there are no size limitations in KNIME.

Best, Iris