Data connectivity & integrationPipeline Builder ExpressionsMode

Mode

Supported in: Batch

Calculate mode of values in column.

Expression categories: Aggregate

Declared arguments

  • Expression - The column of on which mode is computed.
    Expression<String>

Type variable bounds: String accepts String

Output type: String

Examples

Example 1: Base case

Argument values:

  • Expression: values

Given input table:

values
a
b
b
b
c
c
d

Outputs: b


Example 2: Null case

Argument values:

  • Expression: values

Given input table:

values

Outputs: null


Example 3: Null case

Argument values:

  • Expression: values

Given input table:

values
a
null
null
null
c
c
d

Outputs: c