IsUniqueMask / Boolean Layer
Create boolean mask columns identifying unique values in specified columns. Returns True only for values that appear exactly once, complementary to IsDuplicatedMask.
Common applications:
- Validating primary keys
- Finding singular events
- Identifying unique categories
- Data integrity verification
- Finding one-off occurrences
Example:
| Index | Value | Is Unique |
|---|---|---|
| 0 | apple | false |
| 1 | banana | false |
| 2 | apple | false |
| 3 | orange | true |
| 4 | banana | false |
Table
0
0
Table
Mask
[, ...]List of uniqueness checking operations to perform. Each mask creates a new boolean column. Common scenarios:
- Finding truly unique records
- Identifying one-time events
- Detecting singular cases
- Validating unique constraints
At least one mask must be specified.
Select
columnThe column to check for unique values. Works with any data type. The mask will be a boolean column where:
- True indicates a value that appears exactly once
- False indicates ANY occurrence of values that appear multiple times
Essential for identifying truly unique values in the dataset.
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.