Data connectivity & integrationPipeline Builder ExpressionsAny of

Any of

Supported in: Batch

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

Expression categories: Aggregate

Declared arguments

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

Output type: Boolean

Examples

Example 1: Base case

Argument values:

  • Expression: values

Given input table:

values
true
false
true

Outputs: true


Example 2: Null case

Argument values:

  • Expression: values

Given input table:

values
false
false
null

Outputs: false