Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For a value of 25 for Input1, 200 for Input2 and 0.2 for Input3, it will return 40.  For input values which are not exactly equal to the input values listed in the table the output has to be calculated. This function can determine the output  linear interpolation.  For a value of 25 for Input1, 150 for Input2 and 0.2 for Input3, it will return 30. 

Each time series is assigned a variable ID which is used in the actual expression. For definition of input and output time series see transformation – inputs & outputs. 

Only supports linear interpolation. 

Configuration

...

A basic configuration of the function is described below. This describes the main elements and attributes required and provides an example configuration. 

Input1 

required element defining the identifier of the first input time series. 

Input2

...

Input2 

Required element defining the identifier of the second input time series.

...

Required element defining the identifier of the second input time series. 

InterpolationType

...

InterpolationType 

Required element. Has to be linear. 

extrapolationType

...

extrapolationType 

Required element , needs to be  notAllowed . 

output

...

output 

Required element defining the identifier of the output time series. If more than one output is needed, a separate transformation needs to be set up for each output. 

...

Required elements.  These are the names of the columns in CSV file, which should be used for the transformation.

 

 

Code Block
languagexml
linenumberstrue
<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSpy v2007 sp2 (http://www.altova.com) by WL | Delft Hydraulics (WL | Delft Hydraulics) -->
<transformationModule version="1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.wldelft.nl/fews"
                 xsi:schemaLocation="http://www.wldelft.nl/fews http://fews.wldelft.nl/schemas/version1.0/transformationModule.xsd">
   <!--4 variables (with any name) need to be configured to be used as inputs and output.-->
   <variable>
      <variableId>input1</variableId>
      <timeSeriesSet>
         <moduleInstanceId>ThreeDimensionalLookupFromCsvTest</moduleInstanceId>
         <valueType>scalar</valueType>
         <parameterId>H.m</parameterId>
         <locationId>H-2001</locationId>
         <timeSeriesType>external historical</timeSeriesType>
         <timeStep unit="nonequidistant"/>
         <relativeViewPeriod unit="day" start="-1" end="10"/>
         <readWriteMode>add originals</readWriteMode>
      </timeSeriesSet>
   </variable>
   <variable>
      <variableId>input2</variableId>
      <timeSeriesSet>
         <moduleInstanceId>ThreeDimensionalLookupFromCsvTest</moduleInstanceId>
         <valueType>scalar</valueType>
         <parameterId>H.obs</parameterId>
         <locationId>H-2001</locationId>
         <timeSeriesType>external historical</timeSeriesType>
         <timeStep unit="nonequidistant"/>
         <relativeViewPeriod unit="day" start="-1" end="10"/>
         <readWriteMode>add originals</readWriteMode>
      </timeSeriesSet>
   </variable>
   <variable>
      <variableId>input3</variableId>
      <timeSeriesSet>
         <moduleInstanceId>ThreeDimensionalLookupFromCsvTest</moduleInstanceId>
         <valueType>scalar</valueType>
         <parameterId>H.sim</parameterId>
         <locationId>H-2001</locationId>
         <timeSeriesType>external historical</timeSeriesType>
         <timeStep unit="nonequidistant"/>
         <relativeViewPeriod unit="day" start="-1" end="10"/>
         <readWriteMode>add originals</readWriteMode>
      </timeSeriesSet>
   </variable>
   <variable>
      <variableId>output</variableId>
      <timeSeriesSet>
         <moduleInstanceId>ThreeDimensionalLookupFromCsvTest</moduleInstanceId>
         <valueType>scalar</valueType>
         <parameterId>H.updated</parameterId>
         <locationId>H-2001</locationId>
         <timeSeriesType>external historical</timeSeriesType>
         <timeStep unit="nonequidistant"/>
         <relativeViewPeriod unit="day" start="-1" end="10"/>
         <readWriteMode>add originals</readWriteMode>
      </timeSeriesSet>
   </variable>
   <transformation id="3dLookupTest">
      <lookup>
         <threeDimensionalLookup>
            <input1>
               <variableId>input1</variableId>
            </input1>
            <input2>
               <variableId>input2</variableId>
            </input2>
            <input3>
               <variableId>input3</variableId>
            </input3>
            <coefficientSet>
               <!--Only linear interpolation is supported-->
               <interpolationType>linear</interpolationType>
               <!--extrapolation is not supported-->
               <extrapolationType>notAllowed</extrapolationType>
               <input1Unit>m</input1Unit>
               <input2Unit>m</input2Unit>
               <input3Unit>m</input3Unit>
               <outputUnit>m</outputUnit>
               <!--Name of datafile, needs to be in MapLarFiles folder.-->
               <csvFile>lookup3d.csv</csvFile>
               <!--These are the names of the coluumns in CSV file, which should be used for the transformation-->
               <input1Column>Sea level</input1Column>
               <input2Column>Water height</input2Column>
               <input3Column>River water level</input3Column>
               <outputColumn>Simulated data</outputColumn>
            </coefficientSet>
            <output>
               <variableId>output</variableId>
            </output>
         </threeDimensionalLookup>
      </lookup>
   </transformation>
</transformationModule>

...