1

Context: I have a dataset with multiple numeric columns, which I am analysing in Contour. During one step of my analysis I want to find the minimum value of three different columns for every row.

Question: Is there an expression function in Contour I can use to get the minimum or maximum value of two or more columns?

fmsf
  • 36,317
  • 49
  • 147
  • 195
mpSchrader
  • 902
  • 3
  • 20

1 Answers1

2

Generally speaking you can find all available expression functions in the Foundry Contour documentation under the References section.

For this specific case the following two functions can be used:

  • GREATEST: Returns the maximum value of the list of values/columns. Null values are ignored.
  • LEAST: Returns the minimum value of the list of values/columns. Null values are ignored.

The usage would look as follows:

greatest("numeric_column_1", "numeric_column_2", "numeric_column_3")
mpSchrader
  • 902
  • 3
  • 20