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
Example: 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"
Result table:
| Date | Shifts |
|---|---|
| 2020-Nov-16 | 1 |
| 2020-Nov-16 | 2 |
| 2020-Nov-16 | 3 |
| 2020-Nov-17 | 1 |
| 2020-Nov-17 | 2 |
Community examples
- Use case for Repeat Rows (Project; Module: Main; Group: Tab 1; Table: Table 2; Action position: 3)
- Parsing Exceptionally Complex Column (Project; Module: Main; Group: Group 1; Table: Table 2 (parsed); Action position: 6)
- Iterate same row in table a known number of times (Project; Module: Main; Group: Group 1; Table: Table 1; Action position: 3)