Numeric functions

In Wrangler, you can use numeric functions with the set-column directive to perform calculations on one or two columns. The available numeric functions vary depending on how many columns you specify. You can choose to create a new column with the results of the calculations or you can have the results appear in the column where you add the transformation.

If you apply a numeric function to a single column, the behavior is different than if you apply a numeric function to two columns. 

For example, if you use the Multiply function on a single column, you must specify a decimal value to multiply each value in the column by. Wrangler performs the multiplication on the sample data and displays the new values in the same column or in a new column.

If you use the Multiply function on two columns, Wrangler multiplies the values in each row for the selected column and displays the new values in the first column of the transformation.