Table of Contents
REPEAT ROWS
Category: Transform / Advanced
Description
This action 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 #1
Expand the table so there is one row per shift for each day.
Before (source table)
| Date | Shifts |
|---|---|
| 2020-Nov-16 | 3 |
| 2020-Nov-17 | 2 |
After (result table)
| Date | Shifts |
|---|---|
| 2020-Nov-16 | 1 |
| 2020-Nov-16 | 2 |
| 2020-Nov-16 | 3 |
| 2020-Nov-17 | 1 |
| 2020-Nov-17 | 2 |
Action parameters
Column with counts: Shifts
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)