All / List Layer

Check if all elements in each variable-length boolean list are true. Similar to Python's all() or R's all() functions. Returns a boolean column where each value indicates if all elements in the corresponding list are true. Unlike ArrayAll, this supports lists of different lengths.

Example transformation:

listsresult
[true, true]true
[true, true, true]true
[true, false, true]false
[false]false
[null, true]null
[]true

Common applications:

  • Validating dynamic sets of conditions
  • Quality control with varying criteria
  • Checking test suite results
  • Validating flexible rule sets
  • Monitoring system health checks
  • IoT sensor status verification

Note: Empty lists return true (vacuous truth). Lists containing any null values return null. Useful for scenarios where the number of conditions varies by row.

Table
0
0
Table

Select

column

The variable-length boolean list column to evaluate. Common input patterns:

  • Multiple validations: [true, true, true, true]
  • System health checks: [true, true]
  • Complex conditions: [true, false, true]
  • Single flags: [true] Lists can have different lengths across rows, including empty lists

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.