Group a Table
Groups a table by a specified column and optionally aggregates other columns.
Overview
This procedure groups a table by the values in a specific column, and optionally aggregates other columns. This helps you organize and summarize data into meaningful categories. It's useful when you want to analyze totals, averages, or counts within each group, such as total sales by region or number of employees per department.
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
Examples
1. Example 1
create a sample table
group the table's rows by City
2. Example 2
group the table by City where
the other columns are "Salary's Sum", "Age's Mean"
Last updated
Was this helpful?