transformations:generateuids
Table of Contents
GENERATE UNIQUE IDENTIFIERS
Category: Transform / Advanced
Description
This action creates a randomly generated 36-character global unique identifier (GUID) for each row in a table.
Use cases
- This action can be used to generate primary keys in tables.
Action settings
This action has no parameters. A new column will be created at the leftmost position, named "Uid", to hold the unique ID values.
Examples
Example #1
Before (source table)
| Some value |
|---|
| AAA |
| BBB |
| CCC |
After (result table)
| Uid | Some value |
|---|---|
| c50341b2-9a4b-4656-9c61… | AAA |
| a025ab36-1742-405d-9fed… | BBB |
| d5dba128-ee6b-4a3c-94a2… | CCC |
Note: UIDs truncated for brevity.
See also
transformations/generateuids.txt · Last modified: 2025/01/15 19:07 by craigt