Any / Array Layer
Check if any element in each fixed-length boolean array is true. Similar to Python's any() or Numpy's any() for arrays. Returns a boolean column where each value indicates if at least one element in the corresponding array is true.
Example transformation (arrays of length 2):
| arrays | result |
|---|---|
| [false, true] | true |
| [false, false] | false |
| [true, true] | true |
| [null, false] | null |
Common applications:
- Detecting presence of conditions
- Finding matching criteria
- Error detection in multiple checks
- Flag presence verification
- Alternative condition testing
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 alerts: [false, true]
- Dual indicators: [false, false]
- Binary markers: [true, true] 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.