{{ transformations:RepeatRowsAction.png}}
====== 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====
  * [[https://community.easymorph.com/t//1297/3|Use case for Repeat Rows]] ([[https://community.easymorph.com/uploads/short-url/rdUnMPy0VfogVZOnROOoH2JaVUT.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 2//; Action position: //3//)
  * [[https://community.easymorph.com/t//2580/6|Parsing Exceptionally Complex Column]] ([[https://community.easymorph.com/uploads/short-url/18twYeVICxpKyR13IU4TQn2MNnm.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Table 2 (parsed)//; Action position: //6//)
  * [[https://community.easymorph.com/t//2646/4|Iterate same row in table a known number of times]] ([[https://community.easymorph.com/uploads/short-url/vfoRlVfxozi5f8GpH7ISOtSsquO.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Table 1//; Action position: //3//)

\\ 
=====See also=====
  * [[transformations:crossmerge|Cross merge]]