Skip to content

TSTool / Command / FillRepeat

Overview

The FillRepeat command fills missing data in time series by repeating observations until another observation is found. This fill technique is useful, for example, where time series are likely to be step-wise or nearly constant, such as some reservoir and diversion time series.

Command Editor

The command is available in the following TSTool menu:

  • Commands / Fill Time Series Missing Data

The following dialog is used to edit the command and illustrates the syntax of the command.

FillRepeat command editor

FillRepeat Command Editor (see also the full-size image)

Command Syntax

The command syntax is as follows:

FillRepeat(Parameter="Value",...)

Command Parameters

Parameter            Description Default                           
TSList Indicates the list of time series to be processed, one of:
  • AllMatchingTSID – all time series that match the TSID (single TSID or TSID with wildcards) will be processed.
  • AllTS – all time series before the command.
  • EnsembleID – all time series in the ensemble will be processed (see the EnsembleID parameter).
  • FirstMatchingTSID – the first time series that matches the TSID (single TSID or TSID with wildcards) will be processed.
  • LastMatchingTSID – the last time series that matches the TSID (single TSID or TSID with wildcards) will be processed.
  • SelectedTS – the time series are those selected with the SelectTimeSeries command.
 AllTS
TSID The time series identifier or alias for the time series to be processed, using the * wildcard character to match multiple time series. Can be specified using ${Property}. Required if TSList=*TSID
EnsembleID The ensemble to be processed, if processing an ensemble. Can be specified using ${Property}. Required if TSList=*EnsembleID
FillStart The starting date/time for the fill. Can be specified using processor ${Property}. Available period.
FillEnd The ending date/time for the fill. Can be specified using processor ${Property}. Available period.
FillDirection Specify the direction of the fill as Forward or Backward. Forward
MaxIntervals The maximum number of intervals to fill in a data gap. Fill all gaps.
Flag String to flag filled values. Prefix with + to append the string to existing flag values. Can be specified using processor ${Property}. Do not flag filled values.

Examples

See the automated tests.

A sample command file to fill a time series from the State of Colorado’s HydroBase database is as follows:

# 08236500 - ALAMOSA RIVER BELOW TERRACE RESERVOIR
08236500.DWR.Streamflow.Month~HydroBase
FillRepeat(TSList=AllMatchingTSID,TSID="08236500.DWR.Streamflow.Month",FillDirection=Forward)

Troubleshooting

See the main TSTool Troubleshooting documentation.

See Also