Description
The Generate ID activity scans the specified column and generates globally unique identifiers (GUIDs) for any rows where the value is missing or empty. This is especially useful when working with datasets that require unique keys for merging, referencing, indexing, or exporting to systems that mandate unique identifiers (e.g., databases, APIs, etc.).
The generated IDs conform to the standard UUID v4 format, ensuring randomness and uniqueness even across large datasets.
| Type | Description |
|---|
| Data | Dataset where IDs need to be filled. |
Output
| Type | Description |
|---|
| Transformed Data | Same dataset with missing ID values populated using generated GUIDs. |
Configuration Fields
| Field Name | Required | Description |
|---|
| Column | Yes | The name of the column where GUIDs should be generated if empty. Existing values are left unchanged. |
| Name | UserID |
|---|
| Alice | |
| Bob | abcd-1234 |
| Carol | |
Sample Configuration
Sample Output
| Name | UserID |
|---|
| Alice | 550e8400-e29b-41d4-a716-446655440000 |
| Bob | abcd-1234 |
| Carol | 123e4567-e89b-12d3-a456-426614174000 |
