EasyMorph Help

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{ transformations:RepeatRowsAction.png}}
====== 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=====
  * [[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]]