And / Logical Layer
Create a boolean column by applying logical AND operation between two boolean columns. Similar to pandas &, SQL AND, or R's &&.
Truth table:
| Left | Right | Result |
|---|---|---|
| true | true | true |
| true | false | false |
| false | true | false |
| false | false | false |
| null | any | null |
| any | null | null |
Common applications:
- Combined conditions
- Multiple criteria filtering
- Validation rules
- Security checks
- Quality control
Table
0
0
Table
SelectLeft
columnThe first boolean column for the AND operation. Forms the left side of the logical expression. Null values propagate to the result.
SelectRight
columnThe second boolean column for the AND operation. Forms the right side of the logical expression. Null values propagate to the result.
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.