...
You can perform the following calculations on all values in the column:
...
Numeric function
...
Description
...
Adds a positive or negative decimal to each value in the column.
...
Subtracts a positive or decimal integer to each value in the column.
...
Multiplies each value in the column by a positive or negative decimal.
...
...
...
...
...
Raises each value in the column to the power of 2.
...
Returns the square root of each value in a column.
...
Raises each value in the column to the power of 3.
...
...
...
...
...
Returns the absolute value for each value in a column. For example, the absolute value of -10 is 10.
...
Returns the smallest integer greater than or equal to the numeric value in each cell of a column. For example, if the value is 2.21, CEIL returns 3. If the value is 5.88, CEIL returns 6. Likewise, if the value is -5.15, CEIL returns -5.
...
...
...
Returns the sine for each value in a column.
...
Returns the tangent for each value in a column.
...
Returns the inverse of cosine for each value in a column.
...
Returns the inverse of sine for each value in a column.
...
...
...
To apply a numeric calculation to one column, follow these steps:
...
When you run the data pipeline, the transformation is applied to all values in the column.
Performing numeric calculations on values in two columns
You can perform the following numeric calculations on values in each row in two columns:
To apply a numeric calculation to two columns, follow these steps:
To select the columns, click the box to the right of the column names.
Click the drop-down button next to one of the column names and click Calculate.
Select the numeric function you want to perform.
You can choose to create a new column with the results of numeric calculations or overwrite the values in the current column.
Click Apply.
The values change based on the calculation. Wrangler adds the corresponding function as a step in the recipe. For example, if you Add the values in each row of the Q1_Sales and Q2_Sales columns and create a new column called H1_Sales, Wrangler adds the following transformation to the recipe:
set-column :H1_Sales arithmetic:add(Q1_Sales, Q2_Sales)
When you run the data pipeline, Wrangler performs the transformation and creates a new column called H1_Sales with the total of Q1_Sales and Q2_Sales.