Group Rows

Groups the rows of a table by specified criteria.

Overview

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
...