Add rows from one table to another

Goal: Have a button that adds every row from “From” to table “To”

Thanks to Christiaan Huizer for this solution🙌

⁠

Add rows from table "from" to table "to"

⁠

From

From

Name

Sequence(1, From.Count()) // create virtual index

.FormulaMap( / iterate over each number in this index

.addrow( add row

[Table 2].Name,

From.Name.Nth(CurrentValue), // take the list of values in the column and

put each item on the row corresponding

with number from virtual index

[Table 2].Category,

From.Category.Nth(CurrentValue),

[Table 2].Amount,

From.Amount.Nth(CurrentValue)

)