# Array Functions

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

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

The following aggregate functions also create arrays:

|                                                                                                                                                            |                                                                                                       |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------- |
| [arrayagg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/arrayagg "mention")                 | Identifies non-null row values in a column or group and aggregates them into a single array.          |
| [arrayaggdistinct](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/arrayaggdistinct "mention") | Identifies distinct non-null row values in a column or group and aggregates them into a single array. |