MoneyWorks Manual
TableAccumulateColumn (table, key, columnNum, value)
Result Type: Table
Definition: Accumulates the value into the specified column of a table. The table must already have been dimensioned to have sufficient columns.
You can pre-dimension a table on creation by passing the number of columns to the CreateTable function e.g. let myTable = CreateTable(5). Otherwise, the table must have been dimensioned by a previous call to TableAccumulate() with the full complement of columns values.
Example: If using mytable from above:
myTable = TableAccumulateColumn(MyTable, "B", 2, 10)
Adds 10 to column 2 of row "B". The resulting table is:
| Value | Value | |
| A | 2 | 6 |
| B | 1 | 14 |
See Also:
CreateTable: Create an empty accumulator table
Sort: Sort a delimited tabular string
TableAccumulate: Accumulate numeric column data for a key
TableFind: Look up a key in the table
TableGet: Extract data for a key or index found with TableFind
Transpose: Transpose a tabular delimited string