1
0

mv_expand.asciidoc 513 B

12345678910111213141516171819202122232425262728293031
  1. [discrete]
  2. [[esql-mv_expand]]
  3. === `MV_EXPAND`
  4. **Syntax**
  5. [source,esql]
  6. ----
  7. MV_EXPAND column
  8. ----
  9. *Parameters*
  10. `column`::
  11. The multivalued column to expand.
  12. *Description*
  13. The `MV_EXPAND` processing command expands multivalued columns into one row per
  14. value, duplicating other columns.
  15. *Example*
  16. [source.merge.styled,esql]
  17. ----
  18. include::{esql-specs}/mv_expand.csv-spec[tag=simple]
  19. ----
  20. [%header.monospaced.styled,format=dsv,separator=|]
  21. |===
  22. include::{esql-specs}/mv_expand.csv-spec[tag=simple-result]
  23. |===