(TankArray) Function Formula
- Last UpdatedDec 04, 2023
- 1 minute read
The TankArray function uses the following formula. You must use the following form for the Input functions, and then press Ctrl + Shift + Enter keys.
Formula
=TANKARRAY(<TankName>, < PropertyName>,< Unit>, <StartDateTime>, <EndDateTime>, <InnerObject >, <OutputDirection>, <DisplayDates>, <ConnectionName>)
Example
=TankArray("21HAH10CF901 ", "Measured", "MassDefUnit", "1.1.2013 0:00:00", "9.1.2013 0:00:00"; "*", "Vertical", TRUE,"CONN1")
Parameters
|
Parameter |
Description |
|
TankName |
The name of the event stream. |
|
PropertyName |
The name of the property. You can only use parameter values that are defined in the TankPropertyList.xml file. |
|
Unit |
The unit of a value. Depending on the PropertyName the unit value will be different, so you must only use input values in unit list. |
|
StartDateTime |
Starting date/time. (Greater than or Equal to) |
|
EndDateTime |
Ending date/time. (Less than) |
|
InnerObject |
You can get a value of specified inner objects in a complex property like Products or Components. If you do not set any value, the whole string value of the property will return. |
|
OutputDirection |
The direction of the result range. You can only use Vertical or Horizontal. |
|
DisplayDates |
If the result includes starting date/time and ending date/time. |
|
Connection Name (Optional parameter) |
Name of the connection which contains database details. If the connection name is not specified then the default database connection will be used. |