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 revisionBoth sides next revision
transformations:enumerate [2021/04/05 10:13] – [See also] dmitrytransformations:enumerate [2021/07/18 01:28] – 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 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