sum-rows

Sum values in one or more columns

Aggregates values in specified columns grouped by rows.

Arguments

Inputs:

data: The datatable to be aggregated

sum columns:The names of the columns to be summed.

group columns: The names of the columns containing values to be grouped.

Output:

data: A datatable with aggregated data.

Example

Data-flo - Run: Adaptor Demo: Sum-rows - Data-flo

Run the above data-flo, which is set up as shown here. The outputs help show how things are grouped and/or summed. All unique values or combinations for the grouped columns are summed for the sum columns. In this example, col3 is summed each time, with other columns used as group columns.

Example data-flo

Output from example data-flo