# MV_DEDUPE

Removes duplicate values from a multivalued field. Note that MV_DEDUPE may, but won’t always, sort the values in the column.

## Syntax

`MV_DEDUPE(field)`

### Parameters

#### field

A multivalue expression containing the values from which duplicates will be removed.

## Examples

Removes duplicate entries from the array in field `a` and stores the result in a new field `dedupe_a`:

```esql
ROW a=["foo", "foo", "bar", "foo"]
| EVAL dedupe_a = MV_DEDUPE(a)
```

Limitations

MV_DEDUPE may, but won’t always, sort the values in the column.