> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# ArrayAgg

> Use the Sigma ArrayAgg function to identify non-null row values in a column or group and aggregate them into a single array.

This function isn't compatible with all data platform connections. To check if your connection supports it, see [Supported data platforms and feature compatibility](/docs/region-warehouse-and-feature-support#supported-data-platforms-and-feature-compatibility).

The **ArrayAgg** function identifies non-null row values in a column or group and aggregates them into a single array.

The **ArrayAgg** function is an aggregate function.

Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see [Group columns in a table](/docs/create-and-manage-tables#group-columns-in-a-table).

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see [Add summary statistics to a table](/docs/create-and-manage-tables#add-summary-statistics-to-a-table).

To learn more about using aggregate functions, see [Building complex formulas with grouped data](https://www.sigmacomputing.com/resources/training-videos/table-grouping-and-functions#complex-formulas).

## Syntax

```
ArrayAgg(value)
```

Function argument:

|           |                                                  |
| :-------- | :----------------------------------------------- |
| **value** | (required) The column containing values to join. |

## Example

```
ArrayAgg([County Name])
```

For each grouping (grouped by state name) the **ArrayAgg** function returns an array containing non-null values from the corresponding rows in the *County Name* column.

![Table showing counties grouped by state name, with a column aggregating all county names for each state using the ArrayAgg function.](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/a1cd0f3d1858861116ea9d7ae5fde5a5c6f4a8b80ee9d4d758f85b7fdeed4377/assets/docs-images/81a6047-image.png)

## Related resources

* [ListAgg](/docs/listagg)
* [Concat](/docs/concat)