User Tools

Site Tools


transformations:generateuids

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
transformations:generateuids [2016/09/20 23:15] dmitrytransformations: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 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  ^ ^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]] 
transformations/generateuids.1474427723.txt.gz · Last modified: 2016/09/20 23:15 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki