# ArrayDistinct

The **ArrayDistinct** function returns the input array *without* duplicate values and including null values.

### Syntax

```
ArrayDistinct(array)
```

The **ArrayDistinct** function has the following argument:

array Required. The input array that Sigma parses to find and remove duplicates, Must be an array structure; to create single array from a column, use the [arrayagg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/arrayagg "mention") function,

### Example

```
ArrayDistinct(Array('a', 1, 2, 1, ‘a'))
```

This may return `[1, 2, 'a']`. Note that the order elements in the the resulting array may not match the order of the input array.

```
ArrayDistinct([Open prices array])
```

The **ArrayDistinct** function returns the following values for the **Open prices array** column as **Distinct open prices array**; note the differences in array length for each column:

<figure><img src="https://files.readme.io/1b908cd-function-arraydistinct-example.png" alt=""><figcaption></figcaption></figure>