New Rows

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

New Rows


Add new rows.



Add a blank row above every row with an invoice number:


Add blank rows.


Copy each row the number of times in the 'Items' column:


Duplicate rows using column value.







Set Number added according how many rows to add for each existing row.

oSet Number value to the number of new rows to create for each existing row (available when Number added is Same for every row).

oSet Number column to get the number of new rows to create for each existing row from a column (available when Number added is Set from a column).

Set As to add either blank rows, copies of existing rows or user defined rows.

Set With value to set the value used for each column of the new row (available when As is User defined row(s)).

Set Location depending on whether you want new rows added above or below existing rows (available when As is Blank row(s) or User defined row(s)).

Set For depending on whether you wish to add rows to all rows or only rows that meet certain conditions.



You can use Calculate or Javascript transforms to calculate the number for the Number column. E.g. to subtract 1 from the final number of copies wanted to give the number of new rows.


See also