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

SettingDescription
Column with countsSelect 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


See also