ZipWith / Manipulation Layer

Combine two columns using a boolean mask, selecting values from first column where mask is true and from second column where mask is false. Similar to numpy's where() or R's ifelse().

Example combining two price columns based on availability:

Input Data:

Price1	Price2	Available
10.0	15.0	true
20.0	25.0	false
30.0	35.0	true
40.0	45.0	false

Result (zip Price1, Price2 using Available):

Result
10.0
25.0
30.0
45.0

Common applications:

Conditional value selection
Fallback value handling
Data source prioritization
Alternative value merging
State-based selection
Quality-based choosing
Threshold-based combining
Validation-driven merging

Table

SelectFirst

column

Primary column (selected when mask is true). Examples:

Primary price source
Preferred measurements
Main data stream
Higher priority values
Validated readings

SelectSecond

column

Secondary column (selected when mask is false). Must match type of first column. Used for:

Backup values
Alternative measurements
Fallback data source
Secondary readings
Default values

SelectMask

column

Boolean column controlling selection:

true: select from first column
false: select from second column Common mask sources:
Validation flags
Quality indicators
Availability status
Threshold tests

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.