Differences

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

--- transformations:repeatrows [2020/11/27 16:43] – created dmitry
+++ transformations:repeatrows [2021/04/05 01:12] – craigt
@@ Line 1: / Line 1: @@
-===== Repeat Rows =====
+{{ transformations:RepeatRowsAction.png}}
+====== REPEAT ROWS ======
+Category: Transform / Advanced\\
-Repeats each row as many times as specified in given column.
+\\
+=====Description=====
+Repeats each row as many times as specified in a given column.  In the output dataset, the selected column will contain an enumeration of the rows from 1 to n (the number of times the row is repeated).\\
-**Example**
-Table before:
+\\
-^ Date ^ Shifts ^
+=====Action settings=====
-| 2020-Nov-16  |  3 |
+^Setting^Description^
-| 2020-Nov-17  |  2 |
+|Column with counts|Select the column that contains the number of times the row should be repeated.|
-Goal: expand the table so that there is one row per each shift every day. Apply the action to the "Shift" column.
+\\
+=====Examples=====
-Table after:
+**Objective:** Expand the table so there is one row per shift, every day.\\
+\\
+**Source table:**
+^ Date ^ Shifts ^
+| 2020-Nov-16  |   3 |
+| 2020-Nov-17  |   2 |
+\\
+**Action parameters:**
+> Column with counts:  "Shifts"
+\\
+**Output:**
 ^ Date ^ Shifts ^
 | 2020-Nov-16  |  1 |
@@ Line 20: / Line 34: @@
 | 2020-Nov-17  |  2 |
+\\
-** See also **
+=====See also=====
   * [[transformations:crossmerge|Cross merge]]