...
Click Transform> Function variable in the menu.
Enter a function Name for the new function variable, for example: Temperature-Average.
Enter a Title. If there is a title the function name is displayed as: Function Name - Title.
Enter a Unit, for example: deg. C.
Select the appropriate Output type: Numeric or Symbolic.
Select Language for the script. Options: JavaScript, Common Lisp , R or Python.
Enter a function Script and add variable from the list as required (Item selection) and click on the Arrow to put them in the script area.
The standard Script is executed for each row, the result is the last evaluated expression.
Click on Template and select from the list of template functions. On the left part of the window, you can see the function. Then click Insert and the script example will be written on the script area. The templates are only available in Javascript.
Click Save.
...
Expand | ||
---|---|---|
| ||
|
R language
Function variables can be written in R in the editor. For more information on R, see R.
Expand | ||
---|---|---|
| ||
|
Info |
---|
Note: val (& valEx) method are available in the 3 languages and return the specified variable value of the current row |
Expand | ||
---|---|---|
| ||
|
External libraries
In order to compute function variables, several external libraries are included in DATAmaestro Analytics. IF97 is used to compute steam/water properties and CoolProp library is used to computes properties of fluid and humid air.
...