IsInColumn / Boolean Layer
Create boolean mask columns indicating if values in one column exist within another column's set of values. Similar to SQL EXISTS or pandas merge existence check. Returns True when a value appears anywhere in the reference column.
Common applications:
- Foreign key validation
- Dynamic whitelist checking
- Cross-reference verification
- Membership testing
- Relationship validation
Example:
| Index | Product ID | Valid IDs | Is In Valid IDs |
|---|---|---|---|
| 0 | A001 | A001 | true |
| 1 | B002 | A002 | false |
| 2 | A002 | B001 | false |
| 3 | null | A001 | null |
| 4 | B001 | null | null |
Table
0
0
Table
Select
columnThe column to check for membership. Each value is tested for existence in SelectCheck. Null values result in null in the output mask.
SelectCheck
columnThe reference column containing the set of valid values. Must be compatible with Select type. Common uses:
- Master list of IDs
- Valid categories
- Permitted codes
- Reference data
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.