This procedure groups the rows of a table by a specified column, such as "City" or "Department", and returns a list of JSON objects, where each object contains the group name and the rows that belong to it. It's useful when you need to split a dataset into meaningful categories to process each group separately, like handling orders by region or users by role.
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
group the table's rows by criteria
What does it do?
Instructs the system to group the rows of a table by certain criteria.
Where does it go?
This phrase should be written on a new line.
Is it required?
✅ Yes — This phrase is required.
Does it require data?
✅ Yes — A reference to the table must be defined. Replace criteria with the grouping criteria.
Example
group the table's rows by City
Examples
1. Group Rows by a Column
group the table's rows by City
use the above as the groups
process each group as follows
...
