LessThanEqualToColumn / Boolean Layer
Create boolean mask columns by comparing if values in one column are less than or equal to corresponding values in another column. Similar to pandas df['A'] <= df['B'] or R's element-wise comparison.
Common applications:
- Maximum limit compliance
- Budget adherence
- Capacity constraints
- Quota monitoring
- Safety threshold checking
Example:
Index | Cost | Budget | Less Equal |
---|---|---|---|
0 | 80 | 100 | true |
1 | 75 | 75 | true |
2 | null | 90 | null |
3 | 120 | 100 | false |
4 | 60 | null | null |
Compare
[, ...]List of less-than-or-equal comparisons to perform. Each creates a new boolean column. Common scenarios:
- Limit compliance checking
- Budget control monitoring
- Resource allocation tracking
- Safety bound verification
At least one comparison must be specified.
SelectLeft
columnThe column to compare (left side). Must contain ordered values (numeric, datetime, etc.). Null values result in null in the output mask. Common uses:
- Actual costs
- Resource consumption
- Current levels
Forms the left side of the comparison operation.
SelectRight
columnThe column to compare against (right side). Must be comparable with SelectLeft
. Null values result in null in the output mask. Common uses:
- Budget limits
- Resource caps
- Maximum thresholds
Forms the right side of the comparison operation.
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.