User Tools

Site Tools


transformations:enumerate

Differences

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

Link to this comparison view

transformations:enumerate [2014/10/04 01:53]
dmitry created
transformations:enumerate [2019/11/19 12:35] (current)
dmitry added grouping
Line 1: Line 1:
 ===== Enumerate rows ===== ===== Enumerate rows =====
  
-This transformation adds a new column with row number for all rows starting from topIt doesn't have parameters.+This transformation adds a new column with row numbers. Rows can be enumerated either for the entire table, or inside groups defined by combinations of values in particular columnsIn the latter case, row numbers restart from 1 inside each group.
  
 **Example** **Example**
Line 8: Line 8:
 ^Province  ^Amount  ^Total Tax  ^ ^Province  ^Amount  ^Total Tax  ^
 |  ON  | 1000| 125| |  ON  | 1000| 125|
-|  OM  | 1500| 187.5|+|  ON  | 1500| 187.5|
 |  QC  |    2000| 270| |  QC  |    2000| 270|
  
-After transformation+After transformation (enumeration for entire table).
 ^RowNo ^Province  ^Amount  ^Total Tax  ^ ^RowNo ^Province  ^Amount  ^Total Tax  ^
 |  1|  ON  | 1000| 125| |  1|  ON  | 1000| 125|
-|  2|  OM  | 1500| 187.5|+|  2|  ON  | 1500| 187.5|
 |  3|  QC  |    2000| 270| |  3|  QC  |    2000| 270|
 +
 +After transformation (enumeration for each Province).
 +^RowNo ^Province  ^Amount  ^Total Tax  ^
 +|  1|  ON  | 1000| 125|
 +|  2|  ON  | 1500| 187.5|
 +|  1|  QC  |    2000| 270|
transformations/enumerate.txt · Last modified: 2019/11/19 12:35 by dmitry