EqualTo / Boolean Layer

Create boolean mask columns indicating where values exactly match a specified value. Similar to pandas series == value or R's == operator. Returns True where values are equal and False otherwise. Null values result in null.

Common applications:

Finding exact matches
Filtering specific values
Quality control checks
Status identification
Category matching

Example:

Index	Value	Equal to 'apple'
0	apple	true
1	orange	false
2	apple	true
3	null	null
4	APPLE	false

Table

Compare

[, ...]

List of equality comparisons to perform. Each comparison creates a new boolean column. Common scenarios:

Multiple value checks
Parallel status matching
Multi-criteria filtering
Batch condition testing

At least one comparison must be specified.

SelectLeft

column

The column to compare. The comparison respects the column's data type and performs type-appropriate equality checking. Null values in this column result in null in the output.

RightValue

string

The value to compare against. Must be compatible with the column's data type. Examples:

Numeric: '42', '-1.5'
String: 'apple', 'pending'
Boolean: 'true', 'false'

Case-sensitive for string comparisons.

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.