IsIn / Boolean Layer
Create boolean mask columns indicating if values exist within a specified set of values. Similar to pandas isin() or SQL IN operator. Returns True when a value matches any value in the given set.
Common applications:
- Category validation
- Whitelist checking
- Status verification
- Code lookup
- Filter by valid values
Example:
| Index | Status | Is In ['active', 'pending'] |
|---|---|---|
| 0 | active | true |
| 1 | closed | false |
| 2 | pending | true |
| 3 | null | null |
| 4 | ACTIVE | false |
Select
columnThe column to check for membership. Each value is tested against the set of values defined in Check. Null values result in null in the output mask.
Check
[, ...]List of values to check against. Each value creates part of the membership set. Common scenarios:
- Valid status codes
- Acceptable categories
- Known identifiers
- Permitted values
At least one value must be specified.
Value
stringIndividual value to include in the set. Must be compatible with column type. Examples:
- Status codes: 'active', 'pending'
- Categories: 'A', 'B', 'C'
- Valid IDs: '001', '002'
Case-sensitive for string comparisons.
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.