Max function

Returns the maximum value for each row in two columns.

Namespaces

• arithmetic

Input

Numeric values

Output

Numeric values

Syntax

set-column :output_column arithmetic:max(column1,column2)

Example

Returns the maximum price for each row in jan and feb columns and outputs results to a new column max_price:

set-column :max_price arithmetic:max(jan, feb)