title: Knime: Time Series
body: <p>I have a list of time series and I have extracted the time and date field for my calculation. I would Like to insert all the missing dates that fall under two row,Like the one in the screenshot<a href="http://i.stack.imgur.com/hLxXW.png" rel="nofollow">enter image description here</a>. </p>
  
  <p>P.S. I do not have a code to add here.</p>
  
  <p>Update : I have tried to add a lag column to get the next time and then a java script to find the number of interval. Now I have a number of columns to be inserted but I am finding it difficult to insert the rows and also is there any other efficient way than this?</p>
  
  <p>Update 2:</p>
  
  <p>I have tried generating time series like </p>
  
  <p>Date and time   Group</p>
  
  <p>2012-02-24      0</p>
  
  <p>2012-02-24      1</p>
  
  <p>2012-02-24      2</p>
  
  <p>2012-02-24      3</p>
  
  <p>2012-02-25      0</p>
  
  <p>2012-02-25      1</p>
  
  <p>2012-02-25      2</p>
  
  <p>2012-02-25      3</p>
  
  <p>And I have a time series like</p>
  
  <p>Date and time   Group </p>
  
  <p>24.2.2012        1    </p>
  
  <p>24.2.2012        2</p>
  
  <p>24.2.2012        3</p>
  
  <p>25.2.2012        0</p>
  
  <p>25.2.2012        1</p>
  
  <p>25.2.2012        2</p>
  
  <p>25.2.2012        3</p>
  
  <p>May i know how to merge them in knime to achieve</p>
  
  <p>Date and time   Group</p>
  
  <p>2012-02-24      Null</p>
  
  <p>2012-02-24      1</p>
  
  <p>2012-02-24      2</p>
  
  <p>2012-02-24      3</p>
  
  <p>2012-02-25      0</p>
  
  <p>2012-02-25      1</p>
  
  <p>2012-02-25      2</p>
  
  <p>2012-02-25      3</p>