Technical Support for Environmental Data Collection Software
Views: 284
Attachments: 0
Related Articles: 0
Feedback: 0
Helpful: 0
Not Helpful: 0
File Attachments
No attachments were found.

Fill Forward Algorithm

  • Author: Michael Maloney
  • Create Time: 01/28/2013 17:41:48
  • Last Update Time: 01/28/2013 17:45:56
Type: Time-Slice

Introduced in Version: 5.3

Input Parameter: input: double precision (simple input)
Output Parameter:output: double precision


  • NumIntervals (integer, default = 4) - The number of output intervals to fill forward.


This algorithm is used to project an input value by copying it forward in time for the specified number of intervals. This is used for certain modeling programs.

For example, suppose the following parameters:

  • Input: OKVI4.Stage.Inst.1Hour.0.rev
  • Output: OKVI4.Stage.Inst.1Hour.0.fill
  • NumIntervals: 4

Now suppose the 08:00 input value of 5.23 arrives. This algorithm will set the following output values: (08:00 5.23), (09:00 5.23), (10:00 5.23), and (11:00 5.23).

The algorithm will only fill-forward the latest input value in the database. So ingesting or modifying historical input values will have no affect.

The input and output interval may be different. Filling will start on the first output time after or equal to the input time. It also honors the aggregateTimeZone and aggregateTimeOffset properties:


  • Input OKVI4.Stage.Inst.1Hour.0.rev
  • Output: OKVI4.Stage.Inst.~1Day.0.fill
  • NumIntervals: 4
  • AggregateTimeZone: EST5EDT
  • AggregateTimeOffset: 5 hours

Now suppose the Jan 5 08:00 EST input value of 5.23 arrives. This algorithm will set the following output values: (Jan 6 05:00 EST 5.23), (Jan 7 05:00 EST 5.23), (Jan 8 05:00 EST 5.23), and (Jan 9 05:00 EST 5.23).

Post Feedback
This article is:
Name: *
Email: *
Verification Code: *
*Required Field
Related Articles
No Related Articles were found.
No Feedback was found.