Math Functions > General Functions


Merge Time Series

The Merge Time Series function merges data from one time series data set with another time series data set.  The resultant time series data set includes all the data points in the two time series, except where the data points occur at the same time.  When data points from the two data sets are coincident in time, valid values in the primary time series take precedence over valid values in the second selected time series.  However if a coincident point is missing in the primary time series, a valid value in the second time series will be used for the data point in the resultant data set.  If the value is missing for both time series data sets, the value is missing in the resultant data set.

 

The data sets for merging may be either regular or irregular time interval.  The resultant data set is tested to determine if the times have a regular time interval.  If not, it is typed as an irregular time interval data set.

 

Data of any type (i.e., "INST-CUM") or units may be merged with data of any other type or units.  The resultant time series receives the data type and units of the primary time series.

 

To merge two time series data sets:

  1. Choose the General tab of the Math Functions screen and select the Merge Time Series operator.
  2. From the Selected Data Set List, select the primary time series data set.
  3. From the Time Series list, select the second time series data set for merging. 
  4. Click Compute to merge the two data sets.