EasyMorph Help

User Tools

Site Tools

You are here: start » transformations » enumerate
transformations:enumerate

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
Last revisionBoth sides next revision
transformations:enumerate [2021/04/05 10:13] – [See also] dmitrytransformations:enumerate [2021/07/19 01:44] – [Examples] craigt
Line 11: Line 11:
   *Create unique row IDs for datasets that do not already possess a unique key field.   *Create unique row IDs for datasets that do not already possess a unique key field.
   *To define an original record order to re-sort records by downstream.   *To define an original record order to re-sort records by downstream.
- 
  
 \\  \\ 
Line 22: Line 21:
 =====Examples===== =====Examples=====
  
-**Source table**+**Source table:**
 ^Province  ^City  ^Amount  ^Total Tax  ^ ^Province  ^City  ^Amount  ^Total Tax  ^
 |ON  |Toronto  |  1000|  125| |ON  |Toronto  |  1000|  125|
Line 30: Line 29:
 |QC  |Quebec City  |  2000|  270| |QC  |Quebec City  |  2000|  270|
  
 +\\ 
 After transformation (enumeration for entire table). After transformation (enumeration for entire table).
 ^RowNo  ^Province  ^City  ^Amount  ^Total Tax  ^ ^RowNo  ^Province  ^City  ^Amount  ^Total Tax  ^
Line 38: Line 37:
 |  4|QC  |Montreal  |  2000|  270| |  4|QC  |Montreal  |  2000|  270|
 |  5|QC  |Quebec City  |  2000|  270| |  5|QC  |Quebec City  |  2000|  270|
 +\\ 
 After transformation (enumeration for each Province). After transformation (enumeration for each Province).
 ^RowNo  ^Province  ^City  ^Amount  ^Total Tax  ^ ^RowNo  ^Province  ^City  ^Amount  ^Total Tax  ^
Line 46: Line 45:
 |  1|QC  |Montreal  |  2000|  270| |  1|QC  |Montreal  |  2000|  270|
 |  2|QC  |Quebec City  |  2000|  270| |  2|QC  |Quebec City  |  2000|  270|
 +\\ 
 After transformation (enumeration for each Province-Amount pairing). After transformation (enumeration for each Province-Amount pairing).
 ^RowNo  ^Province  ^City  ^Amount  ^Total Tax  ^ ^RowNo  ^Province  ^City  ^Amount  ^Total Tax  ^
Line 54: Line 53:
 |  1|QC  |Montreal  |  2000|  270| |  1|QC  |Montreal  |  2000|  270|
 |  2|QC  |Quebec City  |  2000|  270| |  2|QC  |Quebec City  |  2000|  270|
 +
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//1332/3|String manipulation (REVERSE)]] ([[https://community.easymorph.com/uploads/short-url/67c52KIJt323kknw2Q4vOvlAJ05.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Using actions//; Action position: //4//)
 +  * [[https://community.easymorph.com/t//1351/1|How to order columns by a list of columns]] ([[https://community.easymorph.com/uploads/short-url/bKeuXUgwKo1alDrA03LY5z3tPJv.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Reordered columns//; Action position: //2//)
 +  * [[https://community.easymorph.com/t//1649/14|Update existing data in a database table]] ([[https://community.easymorph.com/uploads/short-url/hauw3ZALjf9UqXAOP8prtLUNbxH.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Sample data//; Action position: //4//)
 +  * [[https://community.easymorph.com/t//1849/4|Iterate through a set of column]] ([[https://community.easymorph.com/uploads/short-url/5icrGfTGgzbmG2l5AuSiqb43QvR.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //in.csv//; Action position: //2//)
 +  * [[https://community.easymorph.com/t//2454/4|.txt to .csv - Multiple Line & Character Length HELP!]] ([[https://community.easymorph.com/uploads/short-url/m3PqCDwhBrNEG2xW23QqEvl8RbX.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //SAMPLE.txt//; Action position: //4//)
  
 \\  \\ 
transformations/enumerate.txt · Last modified: 2022/11/12 22:56 by craigt
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki