Formula node offers greater flexibility to transform your data. Packed with loads of features, you could type in the formula box to highlight fields and apply math operations including simple arithmetic, trigonometric functions and more.
Add a Formula to any node in your Dataflow. Select any node and use the Transform (+) button open the list of options to select Formula. Note that you could work with the node in the dataflow tab or you could use the Properties panel.
To make items distinguishable we have the following color coding:
In the example below, BuiltInParameters.Volume is a data field, 215 is a constant value and sin() and cos() are functions.
For a list of data fields, simply start typing the name of a header in your data and you will see a list of available options. When you have found the field you need in your expression press Enter to add it in your formula.
The same steps can be used to get a list of functions - simply type in the formula box to search and press enter to select.
Formula node supports most basic math operations, such as:
The Add Formula button allows you to add as many formulas as you wish. You can use the drag bar on the left to re-order formulas upwards or downwards to a desired position.
Each formula you write will create a new column to the right of your data. You could also delete a formula by clicking on the "x" button to the right of the formula.
There are a few errors warnings that will guide you in writing a complete expression. You can identify and error when the formula box is highlighted in red. For example:
Here are some common error warnings:
In order to see the values, you will need to name the new column using the text field on the right of the formula box.