User Tools

Site Tools



Category: Transform / Advanced


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

Column with countsSelect the column that contains the number of times the row should be repeated.


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

See also

transformations/repeatrows.txt · Last modified: 2021/07/19 02:19 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki