Step 1: When you create a new connection, for example as shown here Connect To hadoop , you will get to Preview Screen.
Step 2: On preview screen,on right panel, you will see a section of "Other Operations".
Step 3: You get to see various options available under this section :
- Advanced Formula - When you click on this tab under the "Other Operations" section on the right panel, a pop up appears containing all the advanced formulas like : subtraction, multiplication, addition, trigonometric functions like : cos, tan,exponents, floor,square root and many more mathematical operations. You need to supply the parameters(column names) on which the operation has to be performed. After clicking on validate, your selection of operation over the columns is actually validated, in other words it checks whether the columns under selection are eligible for the operation or not. Once validated, Click on "Apply", to obtain the operational result. The result appears as a new column named - " formula " on the rightmost side of the dataset.
