Any / List Layer

Check if any element in each variable-length boolean list is true. Similar to Python's any() or R's any() functions. Returns a boolean column where each value indicates if at least one element in the corresponding list is true. Supports lists of varying lengths within the same column.

Example transformation:

lists	result
[false, true, false]	true
[false, false]	false
[true]	true
[false, false, false]	false
[null, false, true]	null
[]	false

Common applications:

Detecting alerts in monitoring systems
Finding matching criteria in flexible rule sets
Validating permission access (any role matches)
Error detection in variable-length diagnostic tests
Checking feature availability across platforms
Event detection in time-series data

Note: Empty lists return false (vacuous falsehood). Lists containing any null values return null. Particularly useful for scenarios where the number of conditions or checks varies by row, such as event logging or system monitoring.

Table

Select

column

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

Multiple alerts: [false, true, false, true]
System status flags: [false, true]
Single condition: [true]
Permission checks: [false, false, true]
Empty state: [] Lists can have different lengths across rows, allowing flexible condition checking

AsColumn

name

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.