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.

*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]
|===