Group By

GroupBy is used to group the identical rows of tabular data. For example, if a particular column has the same values in different rows, groupBy will group those rows.

When you apply GroupBy to a DataModel, it transforms it and creates a new DataModel.

Now, let's apply groupBy operation on the tabular data of a DataModel given below:

The code to group the above tabular data with respect to the Country and Quantity column is shown below:

GroupColumn columnData = new GroupColumn {
    "Country",
    "Quantity"
};

DataModel groupModel = model.GroupBy(columnData);COPY

In the above code:

• GroupColumn is a class.
• columnData is the class object which holds information of the data to be grouped.
• Country and Quantity are the column names from the above tabular data.
• DataModel is a class.
• groupModel is the object which holds the resultant data.

The output after running the above code looks like:

If you want to perform GroupBy on a column of data type DateTime, you can use the DateGrouping enum of the class GroupColumn. Refer to the code below:

GroupColumn groupColumnSet = new GroupColumn {
    {"Country" },
    {"OrderDate",GroupColumn.DateGrouping.YEAR },
    {"city" },
    {"sales" },
    {"shippedDate",GroupColumn.DateGrouping.QUARTER }
};COPY

In the above code:

DateGrouping is an enum of the type GroupColumn.DateGrouping. It accepts the following values:

• YEAR
• HALFYEAR
• QUARTER
• MONTH
• DATE
• HOUR
• MINUTE
• SECOND
• MILLISECOND
• NONE