All / Array Layer
Check if all elements in each fixed-length boolean array are true. Similar to Python's all() or Numpy's all() for arrays. Returns a boolean column where each value indicates if all elements in the corresponding array are true.
Example transformation (arrays of length 2):
| arrays | result |
|---|---|
| [true, true] | true |
| [true, false] | false |
| [false, false] | false |
| [null, true] | null |
Common applications:
- Validating multiple conditions
- Checking array-wide compliance
- Quality control checks
- Filter validation
- Data consistency verification
Note: Arrays must have the same fixed length across all rows. Null arrays or arrays containing null values return null.
Table
0
0
Table
Select
columnThe fixed-length boolean array column to evaluate. Common input patterns:
- Two-state validation: [true, true]
- Dual checks: [true, false]
- Binary flags: [false, false] All arrays must have the same length
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.