transformations:repeatrows
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
transformations:repeatrows [2020/11/27 16:43] – created dmitry | transformations:repeatrows [2021/07/17 23:33] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Repeat Rows ===== | + | {{ transformations: |
+ | ====== | ||
+ | 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. | ||
- | **Example** | ||
- | Table before: | + | \\ |
- | ^ Date ^ Shifts | + | =====Action settings===== |
- | | 2020-Nov-16 | + | ^Setting^Description^ |
- | | 2020-Nov-17 | + | |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 " | + | \\ |
+ | =====Examples===== | ||
- | Table after: | + | **Objective:** Expand the table so there is one row per shift, every day.\\ |
+ | \\ | ||
+ | **Source table:** | ||
+ | ^ Date ^ Shifts ^ | ||
+ | | 2020-Nov-16 | ||
+ | | 2020-Nov-17 | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Column with counts: | ||
+ | \\ | ||
+ | **Result table:** | ||
^ Date ^ Shifts ^ | ^ Date ^ Shifts ^ | ||
| 2020-Nov-16 | | 2020-Nov-16 | ||
Line 20: | Line 34: | ||
| 2020-Nov-17 | | 2020-Nov-17 | ||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
- | ** See also ** | + | \\ |
+ | =====See also===== | ||
* [[transformations: | * [[transformations: | ||
transformations/repeatrows.txt · Last modified: 2021/07/19 02:19 by craigt