Aggregates the given datatable on the given column, grouped by the given columns.

Syntax

Smartsite SXML CopyCode image Copy Code
datatable datatable.aggregate(datatable dataTable, string column, boolean groupByCaseInsensitive)
datatable datatable.aggregate(datatable dataTable, string column, boolean groupByCaseInsensitive, string[ ] groupByColumnNames)

Parameters

Name Data Type Description
dataTable DataTable The datatable that will be aggregated.
column String The column on which the aggregate function is performed.
groupByCaseInsensitive Boolean Indicates if the group by should be case insensitive.
groupByColumnNames String[ ] The column on which the grouping will occur.

Return Value

Data Type Description
DataTable Return a new datatable containing the aggregated rows and their aggregated values.

Expand image Example

SXML