Description

This function evaluates to a list composed of the values in a column of a given Agg Series Slots (or for GetSlotValsByCol, it could be a periodic slot) within a time range.

Type

LIST{NUMERIC}

Arguments

Type

Meaning

1

SLOT

the agg series slot (or for GetSlotValsByCol, it could be a periodic slot) whose values to get

2

DATETIME

start datetime

3

DATETIME

end datetime

4

NUMERIC

the column (interpreted as a 0-based integral index)

Evaluation

A list is generated by looking up each value in the given column of the slot, beginning with the start datetime, and ending with the end datetime. All slot values in the range are returned, regardless of the slot data’s timestep resolution vis-a-vis that of the run control.

Mathematical
Expression

Comments

If the slot is an Agg Series Slot and the start datetime or end datetime does not match one of the slot’s values’, or if the start datetime is after the end datetime, this function aborts the run with an error. For GetSlotValsByCol, if one of the slot values within the desired time range is a NaN, the function exits the rule with an early termination. For GetSlotValsByColNaNToZero, it converts any NaNs into zero.

For periodic slots and GetSlotValsByCol, the dates used are those within the range and falling on a run timestep.