Divides each value in the column by a positive or negative decimal or divides each value in two columns.
Namespace
arithmetic
decimal
Input
Numeric values
Output
Numeric values
Applied to one column
Divides each value in a column by the specified positive or negative decimal value.
Syntax
set-column :output_column column / <decimal_value>
Examples
Divides each value by 10 in the price
column and outputs results to the price_new
column:
set-column :price_new price / 10
set-column :price_new decimal:divide(price,10
)
Applied to two columns
Divides values in two columns.
Syntax
set-column :output_column arithmetic:divideq(column1,column2)
Example
Divides values in and col1
and col2
columns and outputs results to a new column col3
:
set-column :col3 arithmetic:divideq(col1, col2)