Convert annual to quarterly

KNIME Analytics Platform
1

Hi all,

How would I convert a table of annual values to quarterly? The table is a time series (converted from text values e.g. '2009') mapping a year to different values. Any thoughts appreciated. I'm trying to avoid reading in the data 4 times and melding it together - which I could do but seems ugly.

Input:

Year [Time Series] A [Double] B [Double] C [Double]
2008-01-01 1.1 ? ?
2009-01-01 2.2 4.4 ?
2010-01-01 3.3 5.5 6.6

 

Desired Output:

Year A B C
2008-03-31 1.1 ? ?
2008-06-30 1.1 ? ?
2008-09-30 1.1 ? ?
2008-12-31 1.1 ? ?
2009-03-31 2.2 4.4 ?
2009-06-30 2.2 4.4 ?
2009-09-30 2.2 4.4 ?
2009-12-31 2.2 4.4 ?
2010-03-31 3.3 5.5 6.6
2010-06-30 3.3 5.5 6.6
2010-09-30 3.3 5.5 6.6
2010-12-31 3.3 5.5 6.6

 

2

Have you tried Cross Joiner? Together with time series generator…

3

Ok thanks! I did end up using the 'Cross Join' node with my original table as input in addition to this table generated with 'Table Creator' node:

column1 column2
Q1 3
Q2 6
Q3 9
Q4 12

This gave me four copies of each row.  column1 wasn't absolutely necessary but I used column2 for the time shift.

To achieve the quarter end time shift I used the 'Time Shift' node twice in a row.  The first shift was -1 Day (to give me year end values) and in the second shift  I selected 'Use shift value from column' and used column2 with 'Month' granuarity.