elasticsearch/docs/reference/esql/processing-commands/mv_expand.asciidoc

[discrete]
[[esql-mv_expand]]
=== `MV_EXPAND`

preview::[]

The `MV_EXPAND` processing command expands multivalued columns into one row per
value, duplicating other columns.

**Syntax**

[source,esql]
----
MV_EXPAND column
----

*Parameters*

`column`::
The multivalued column to expand.

[WARNING]
======
The output rows produced by `MV_EXPAND` can be in any order and may not respect
preceding `SORT` commands. To guarantee a certain ordering, place a `SORT` after any
`MV_EXPAND` commands.
======

*Example*

[source.merge.styled,esql]
----
include::{esql-specs}/mv_expand.csv-spec[tag=simple]
----
[%header.monospaced.styled,format=dsv,separator=|]
|===
include::{esql-specs}/mv_expand.csv-spec[tag=simple-result]
|===