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).

Example: Expand the table so there is one row per shift, every day.

Source table:

Action parameters:

Column with counts: "Shifts"

Result table:

• 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)

• Cross merge