EqualToColumn / Boolean Layer
Create boolean mask columns by comparing values between two columns element-wise. Similar to pandas df['A'] == df['B'] or R's equal() function. Returns True where corresponding values match exactly.
Common applications:
- Data verification
- Change detection
- Cross-validation
- Quality control
- Version comparison
Example:
| Index | Column A | Column B | Equal |
|---|---|---|---|
| 0 | apple | apple | true |
| 1 | 42 | 42 | true |
| 2 | null | apple | null |
| 3 | orange | ORANGE | false |
| 4 | 42.0 | 42 | true |
Compare
[, ...]List of column equality comparisons to perform. Each creates a new boolean column. Common scenarios:
- Multiple field validations
- Batch data verification
- System synchronization checks
- Cross-reference validation
At least one comparison must be specified.
SelectLeft
columnThe first column for comparison. Must be comparable with SelectRight. If this column contains null values, the result will be null for those rows.
SelectRight
columnThe second column for comparison. Must be comparable with SelectLeft. If this column contains null values, the result will be null for those rows. Common pairs:
- predicted vs. actual values
- old vs. new versions
- manual vs. automated results
Type conversion may occur for compatible types (e.g., int vs. float).
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.