I have  FFT frequency feed  from a particular Node . To make the time difference linear , I have a day into four group(6 hours each) and now i would like to insert the missing rows . For example see below.I have tried generating time series likeDate and time      Group2012-02-24             02012-02-24            12012-02-24            22012-02-24            32012-02-25            02012-02-25            12012-02-25            22012-02-25            3And I have a time series likeDate and time Group24.2.2012            124.2.2012            224.2.2012            325.2.2012           025.2.2012           125.2.2012            225.2.2012           3May I know how to merge them in knime to achieve the below.Date and time Group2012-02-24      Null2012-02-24         12012-02-24         22012-02-24         32012-02-25         02012-02-25         12012-02-25         22012-02-25         3
Merging Two Tables
data cleaning;databases;sql