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:
lists | result |
---|---|
[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.
Select
columnThe 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
AsColumn
nameName 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.