LessThanEqual / Operator Layer

Compare if values in a column are less than or equal to a constant or another column's values. Similar to pandas df['A'] <= df['B'] or df['A'] <= 5, numpy.less_equal(), or R's <= operator. Returns a boolean column.

Mathematical form: $y_{i} = {t r u e f a l se if x_{i} \leq v otherwise$

Common applications:

Maximum allowance checks (weight <= limit)
Resource utilization (usage <= capacity)
Service level agreements (response_time <= max_time)
Credit limits (spending <= credit_line)
Environmental monitoring (emissions <= threshold)
Process control (variance <= tolerance)

Note: Includes equality in comparison, suitable for inclusive upper bounds.

Table

SelectLeft

column

The primary column for comparison. Forms the left side of the less-than-or-equal check (e.g., measured value, actual quantity, current level).

SelectRight

oneof

Integer

Value

i64

64-bit signed integer maximum threshold. Range: -2^63 to 2^63-1. Use cases:

Maximum load (connections <= 1000)
Age limits (age <= 18)
Error tolerance (errors <= 5)
Rating scales (score <= 100)

UnsignedInteger

Value

u64

64-bit unsigned integer maximum threshold. Range: 0 to 2^64-1. Examples:

File size limits (size <= max_size)
Transaction caps (amount <= daily_limit)
Queue constraints (items <= capacity)
Resource allocation (used <= allocated)

Float

Value

f64

64-bit floating-point maximum threshold. Common scenarios:

Risk thresholds (risk_score <= 0.8)
Quality control (defect_rate <= 0.01)
Performance targets (latency <= 1.5)
Financial ratios (debt_ratio <= 0.4)

Column

Other

column

The comparison column for less-than-or-equal check. Common pairs:

expenses <= budget (financial control)
actual <= planned (project tracking)
current <= maximum (limit monitoring)
output <= capacity (production control)

PropagateNull

bool

true

Controls null value handling:

true: propagates nulls (null <= value returns null)
false: treats nulls as false

Default is true for standard SQL-like null behavior

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.