Differences

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

--- transformations:enumerate [2019/11/19 07:35] – added grouping dmitry
+++ transformations:enumerate [2021/03/21 14:26] – craigt
@@ Line 1: / Line 1: @@
-===== Enumerate rows =====
+{{ transformations:EnumerateRowsAction.png}}
+====== ENUMERATE ROWS ======
+Category: Transform / Basic
-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 columns. In the latter case, row numbers restart from 1 inside each group.
+=====Description=====
+This action adds a new column with row numbers. Rows can be enumerated for either the entire table, or inside groups defined by combinations of values in particular columns. In the latter case, row numbers restart from 1 inside each group.\\
-**Example**
+\\
+=====Action settings=====
+^Setting^Description^
+|Enumerate in groups|Select this option to restart row numbering at each unique value in the selected column(s). |
+|Column list|This list appears when the //Enumerate in groups// is selected.  Select which columns are taken into account to\\ form unique values when numbering columns.  Column numbering will restart at 1 for each unique value or value\\ combination across all selected columns.|
+\\
+=====Examples=====
+**Source table**
+^  Province  ^  City  ^  Amount  ^  Total Tax  ^
+|  ON  |  Toronto  |  1000|  125|
+|  ON  |  Ottawa  |  1000|  125|
+|  ON  |  Brampton  |  2000|  250|
+|  QC  |  Montreal  |  2000|  270|
+|  QC  |  Quebec City  |  2000|  270|
-Before transformation
-^Province  ^Amount  ^Total Tax  ^
-|  ON  | 	1000| 	 125|
-|  ON  | 	1500|	 187.5|
-|  QC  |    	2000|	270|
 After transformation (enumeration for entire table).
-^RowNo ^Province  ^Amount  ^Total Tax  ^
+^  RowNo  ^  Province  ^  City  ^  Amount  ^  Total Tax  ^
-|  1|  ON  | 	1000| 	 125|
+|  1|  ON  |  Toronto  | 	1000|  125|
-|  2|  ON  | 	1500|	 187.5|
+|  2|  ON  |  Ottawa  | 	1000|  125|
-|  3|  QC  |    	2000|	270|
+|  3|  ON  |  Brampton  |  2000|  250|
+|  4|  QC  |  Montreal  |  2000|  270|
+|  5|  QC  |  Quebec City  |  2000|  270|
 After transformation (enumeration for each Province).
-^RowNo ^Province  ^Amount  ^Total Tax  ^
+^  RowNo  ^  Province  ^  City  ^  Amount  ^  Total Tax  ^
-|  1|  ON  | 	1000| 	 125|
+|  1|  ON  |  Toronto  | 	1000|  125|
-|  2|  ON  | 	1500|	 187.5|
+|  2|  ON  |  Ottawa  | 	1000|  125|
-|  1|  QC  |    	2000|	270|
+|  3|  ON  |  Brampton  |  2000|  250|
+|  1|  QC  |  Montreal  |  2000|  270|
+|  2|  QC  |  Quebec City  |  2000|  270|
+After transformation (enumeration for each Province-Amount pairing).
+^  RowNo  ^  Province  ^  City  ^  Amount  ^  Total Tax  ^
+|  1|  ON  |  Toronto  | 	1000|  125|
+|  2|  ON  |  Ottawa  | 	1000|  125|
+|  1|  ON  |  Brampton  |  2000|  250|
+|  1|  QC  |  Montreal  |  2000|  270|
+|  2|  QC  |  Quebec City  |  2000|  270|
+\\
+=====See also=====
+  *[[transformations:enumerategroups|Enumerate groups]]