Data connectivity & integrationPipeline Builder ExpressionsAll of

All of

Supported in: Batch

Calculate the boolean 'and' of an aggregate. Nulls are considered false.

Expression categories: Aggregate

Declared arguments

  • Expression - The column on which to compute 'all'.
    Expression<Boolean>

Output type: Boolean

Examples

Example 1: Base case

Argument values:

  • Expression: values

Given input table:

values
true
false
true

Outputs: false


Example 2: Null case

Argument values:

  • Expression: values

Given input table:

values
true
true
null

Outputs: false