Differences

This shows you the differences between two versions of the page.

--- transformations:generateuids [2016/09/20 23:15] – dmitry
+++ transformations:generateuids [2025/01/15 19:07] (current) – revise to 2025 format craigt
@@ Line 1: / Line 1: @@
-===== Generate UIDs =====
+{{ transformations:GenerateUidsAction.png}}
+====== GENERATE UNIQUE IDENTIFIERS ======
+Category: Transform / Advanced\\
-This transformation creates randomly generated global unique identifiers (GUID) for each row in a table.
+\\
+=====Description=====
+This action creates a randomly generated 36-character global unique identifier (GUID) for each row in a table.\\
-The transformation doesn't have parameters and can be used to generate primary keys in tables.
+\\
+=====Use cases=====
+  * This action can be used to generate primary keys in tables.
-**Example**
+\\
+=====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-1f0a796b04ed | AAA  |
+|c50341b2-9a4b-4656-9c61... | AAA  |
-|a025ab36-1742-405d-9fed-1072e02cdf89 | BBB  |
+|a025ab36-1742-405d-9fed... | BBB  |
-|d5dba128-ee6b-4a3c-94a2-882b57c35bd6 | CCC  |
+|d5dba128-ee6b-4a3c-94a2... | CCC  |
+Note:  UIDs truncated for brevity.
+\\
+=====See also=====
+  * [[transformations:enumerate|Enumerate rows]]