| newRows | amount |
|---|---|
| 1 | 300 |
| 2 | 300 |
| 3 | 300 |
| id | amount | row_number |
|---|---|---|
| 1 | 300 | 1 |
| 2 | 300 | 1 |
| 2 | 300 | 2 |
| 3 | 300 | 1 |
| 3 | 300 | 2 |
| 3 | 300 | 3 |
| id | amount | row_number | disaggregated_amount |
|---|---|---|---|
| 1 | 300 | 1 | 300 |
| 2 | 300 | 1 | 150 |
| 2 | 300 | 2 | 150 |
| 3 | 300 | 1 | 100 |
| 3 | 300 | 2 | 100 |
| 3 | 300 | 3 | 100 |
Configuration
The Create Rows tool has one required input and an optional input.1
Select column with number of rows to create
Select the column that contains an integer/whole number which represents the number of new rows you would like to create for the particular row in your dataset.The values of the column doesn’t have to be different; you can use a Calculate tool to create a static number representing the number of rows you would like to create in your dataset.
2
Optional: Select column(s) to disaggregate
This is an optional step. Select the column(s) that you want to disaggregate based on the number of rows that are being created. Behind the scenes this columnn is divided by the number of rows being created.
When To Use
Use the Create Rows tool when you want to generate new rows in your dataset. Examples could include:- Creating new rows for each period an bill/invoice is accounting for and disaggregate the amount. This is highly relevant for revenue recognition in finance (or accrual-based accounting)
- Use the Create Rows tool to create every date between a start and an end date. Start by calculating the difference between the two dates using the Date Difference tool and use the column which that tool generates in the first input of the Create Rows tool.