# Array Functions

Array functions create, manage, and manipulate arrays (lists of indexed values).

|                                                                                                                         |                                                                                                                              |
| ----------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------- |
| [Array](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/array.md)                         | Returns an array containing specified values.                                                                                |
| [ArrayContains](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arraycontains.md)         | Searches for a specific value in an array. If the value is found, the function returns `True`, otherwise it returns `False`. |
| [ArrayDistinct](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arraydistinct.md)         | Returns the array without duplicate values.                                                                                  |
| [ArrayExcept](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arrayexcept.md)             | Returns an array of all unique elements from one specified array not included in another specified array.                    |
| [ArrayIntersection](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arrayintersection.md) | Compares two arrays and returns an array of all overlapping elements, without duplicates.                                    |
| [ArrayJoin](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arrayjoin.md)                 | Joins elements of an array into a single text string.                                                                        |
| [ArrayLength](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arraylength.md)             | Determines the number of entries in an array, or list.                                                                       |
| [ArraySlice](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/arrayslice.md)               | Returns a portion of an array, defined by the starting index and length.                                                     |
| [Sequence](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions/sequence.md)                   | Returns an arithmetic sequence as an array of integers based on a specified range and increment                              |

The following aggregate functions also create arrays:

|                                                                                                                           |                                                                                                       |
| ------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------- |
| [ArrayAgg](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/arrayagg.md)                 | Identifies non-null row values in a column or group and aggregates them into a single array.          |
| [ArrayAggDistinct](/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/arrayaggdistinct.md) | Identifies distinct non-null row values in a column or group and aggregates them into a single array. |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/array-functions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.