| scrollbar |
|---|
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
The Lookup table module is used to derive a simple value based on combining input values of different time series in the forecast database. These are then used to search in a multi-dimensional lookup table to derive the requested output. The module may also be employed to derive a decision based on a hierarchic set of rules (critical conditions table).
...
Coastal_Lookup_Forecast 1.00 default.xml
Coastal_Lookup_Forecast | File name for the Coastal_Lookup_Forecast configuration. |
1.00 | Version number |
default | Flag to indicate the version is the default configuration (otherwise omitted). |
Figure 78 Elements of the lookup table configuration.
LookupSet
Root element of the definition of a lookup table. Multiple entries may exist.
...
- lookupSetId : Id of the lookup table. Used for reference purposes only (e.g. in log messages).
inputVariable
Definition of input variable to be used in the lookup table. For each entry in the lookup table an input variable will need to be identified. The variableId is used to refer to the time series. See Transformation Module for definition of inputVariable configuration.outputVariable
Definition of output variable as a result of the lookup table. A single timeSeriesSet for one location output variable per lookup table is defined.comment
Optional comment on lookup display configuration. Used for reference purposes only.criticalConditionLookup
Root element for definition of a critical condition table. If no results can possibly be returned by any of the conditions specified, a defaultValue should be defined as a set of rules.
...
- Id Id of the criticalConditionTable. Used for reference purposes only
simpleTableLookup
Root element for definition of a simple table lookup. Multiple entries may exist.
...
- lookUpVariableId Id of the input variable to be used in the table.
- outputVariableId Id of the output variable.
- rows number of rows in lookup table (if lookup is defined per row then this is equal to 1).
- cols number of columns in lookup table (if lookup table is defined per col then this is equal to 1).
- type Optional indication of type of value in lookup table (same type will be returned). Enumeration of "float"or "int".
multiDimensionalLookup
Root element for definition of a multidimensional lookup table. Multiple entries may exist.
...
- lookUpRowVariableId Id of the input variable to be used in the table for finding relative row position.
- lookUpColVariableId Id of the input variable to be used in the table for finding relative column position..
- outputVariableId Id of the output variable.
- rows number of rows in lookup table (matrix).
- cols number of columns in lookup table (matrix).
- type Optional indication of type of value in lookup table. Enumeration of "float"or "int".
Anchor _Toc154574430 _Toc154574430
criticalConditionLookupAnchor _Toc95297284 _Toc95297284 
Figure 79 Elements of the criticalConditionLookup configurationcriticalCondition
Definition of a critical condition as a set of rules. Multiple entries may exist. When multiple entries do exist, then these will be resolved sequentially until a condition defined is met. The result is then written to the output time series. Each condition holds a set of rules. Each rule is resolved to a Boolean true or false. Rules can be combined in ruleGroups using Boolean operators. If a "true" value returned through combination of all rules and ruleGroups specified, then the conditions specified are met.
...
- rule: string value for result to be returned if conditions specified are met (for reference purposes only).
- ruleIndex: index value returned if conditions specified are met. This is the value returned in the output time series. Value given is either a numerical value enclosed in quotes (e.g. "4" or "Missing" to indicate a missing value should be returned).
ruleCriteria
Root element for definition of set of rules and ruleGroups. Multiple ruleCriteria can be defined. These are combined using the logical operator defined.ruleCriteriaLogicalOperator
Operator for combining ruleCriteria to single Boolean value. Enumeration of "and " and "or ".rule
Definition of a rule to resolve to a Boolean value.
...
- variable: id of Input variable to use in evaluating rule
- operator: Definition of operator to be used in comparison. Enumeration of options include;
- lt : less than
- le : less than or equal to
- eq : equal to
- ge : greater than or equal to
- gt : greater than
- ne : not equal to
- value: Value to compare input variable to using operator defined.
- logical: optional definition of logical operator to combine sequence of rules (for rules defined in a rule group only). Enumeration of "and " and "or ".
ruleGroup
Root element for defining a rule group. A rule group is a sequence of rules. Each rule is configured as defined above, and combined using the logical operator given in the rule. The logical operator need not be included in the last rule defined.
Example:
defaultValue
The default value element is identical to the specification of a criticalConditon as described above.
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
Figure 80 Elements of the simpleTableLookup configuration
LookUpData
Row vector of data used to find relative position of input variable.
...
- number : optional definition of number of entries (otherwise inferred from data provided)
- type : optional type indication of data. Enumeration of "float" and "int".
- separator : optional indication of separator string used between values. Default is space. Enumeration of;
- space
data
Element containing data vector separated by separator character defined.rowwise
Element to define vector of data to lookup data in. Data value at relative position is returned. Attributes are same as LookUpData element. Use this element if data is provided as a row.columnwise
Element to define vector of data to lookup data in. Data value at relative position is returned. Use this element if data is provided as a one value per row (as a column)
...
- number : optional definition of number of entries (otherwise inferred from data provided)
- type : optional type indication of data. Enumeration of "float" and "int".
- separator : optional indication of separator string used between values. Default is space. Enumeration of;
- lineseparator
info
Element containing information on how values are determined in lookup vector using the relative position determined.info:extrapolation
Definition of how to extrapolate when relative position is above last or below first value in vector. Enumeration includes; - none : no extrapolation, missing value is returned
- minmax : limit values returned to minimum/maximum of vector
- linear : linear extrapolation using last or first two values in vector
info:interpolation
Definition of how to interpolate between values in vector. Enumeration includes; - class : returns closest value in vector.
- linear : linear interpolation
Example:
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
Figure 81 Elements of the multiDimensionalLookup configuration
lookupColData
Row vector of data used to find relative position in matrix columns of input variable defined as lookUpColVariableId.
...
- number : optional definition of number of entries (otherwise inferred from data provided)
- type : optional type indication of data. Enumeration of "float" and "int".
- separator : optional indication of separator string used between values. Default is space. Enumeration of;
- space
lookupRowData
Row vector of data used to find relative position in matrix rows of input variable defined as lookUpRowVariableId.
...
- number : optional definition of number of entries (otherwise inferred from data provided)
- type : optional type indication of data. Enumeration of "float" and "int".
- separator : optional indication of separator string used between values. Default is space. Enumeration of;
- space
rowwise
Element for defining rows of marix as a vector of data on one line. For definition see simpleTableLookup. The number of rowwise elements provided must be equal to the number of columns defined in the multiDimensionalLookup element. Each rowwise vector must contain as many values as defined in cols in the multiDimensionalLookup element.colwise
Element for defining rows of marix as a vector of data on one multiple lines. For definition see simpleTableLookup element. The number of colwise elements provided must be equal to the number of columns defined in the multiDimensionalLookup element. Each colwise vector must contain as many values as defined in cols in the multiDimensionalLookup element.Info
See definition in simpleTableLookup element
...