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.
Prerequisite Data
These required data elements must be present in the automation before using the procedure.
Data Name
Data Type
the table
Table
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
Examples
1. Group by Column with Aggregation
create a table where
the headers are "Department", "Employee", "Salary"
the rows are
"HR", "John Doe", 50000
"HR", "Jane Doe", 60000
"IT", "Jim Beam", 70000
group the table by Department with
the other columns are "Salary's Sum"
2. Group by Column with No Additional Columns
create a table where
the headers are "Project", "Hours Worked"
the rows are
"Project A", 10
"Project B", 20
"Project A", 15
group the table by Project
Last updated
Was this helpful?