transformations:repeatrows
This is an old revision of the document!
Repeat Rows
Repeats each row as many times as specified in given column.
Example
Table before:
| Date | Shifts |
|---|---|
| 2020-Nov-16 | 3 |
| 2020-Nov-17 | 2 |
Goal: expand the table so that there is one row per each shift every day. Apply the action to the "Shift" column.
Table after:
| Date | Shifts |
|---|---|
| 2020-Nov-16 | 1 |
| 2020-Nov-16 | 2 |
| 2020-Nov-16 | 3 |
| 2020-Nov-17 | 1 |
| 2020-Nov-17 | 2 |
See also
transformations/repeatrows.1606513394.txt.gz · Last modified: 2020/11/27 16:43 by dmitry