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:

IndexColumn AColumn BEqual
0appleappletrue
14242true
2nullapplenull
3orangeORANGEfalse
442.042true
Table
0
0
Table

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.

The first column for comparison. Must be comparable with SelectRight. If this column contains null values, the result will be null for those rows.

The 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).

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.