transformations:repeatrows
This is an old revision of the document!
Table of Contents
REPEAT ROWS
Category: Transform / Advanced
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).
Action settings
| Setting | Description |
|---|---|
| Column with counts | Select the column that contains the number of times the row should be repeated. |
Examples
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 |
| 2020-Nov-16 | 2 |
| 2020-Nov-16 | 3 |
| 2020-Nov-17 | 1 |
| 2020-Nov-17 | 2 |
See also
transformations/repeatrows.1617599563.txt.gz · Last modified: 2021/04/05 01:12 by craigt