mv_concat.asciidoc 934 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. [discrete]
  2. [[esql-mv_concat]]
  3. === `MV_CONCAT`
  4. *Syntax*
  5. [.text-center]
  6. image::esql/functions/signature/mv_concat.svg[Embedded,opts=inline]
  7. *Parameters*
  8. `v`::
  9. Multivalue expression.
  10. `delim`::
  11. Delimiter.
  12. *Description*
  13. Converts a multivalued string expression into a single valued column containing
  14. the concatenation of all values separated by a delimiter.
  15. *Supported types*
  16. include::types/mv_concat.asciidoc[]
  17. *Examples*
  18. [source.merge.styled,esql]
  19. ----
  20. include::{esql-specs}/string.csv-spec[tag=mv_concat]
  21. ----
  22. [%header.monospaced.styled,format=dsv,separator=|]
  23. |===
  24. include::{esql-specs}/string.csv-spec[tag=mv_concat-result]
  25. |===
  26. To concat non-string columns, call <<esql-to_string>> first:
  27. [source.merge.styled,esql]
  28. ----
  29. include::{esql-specs}/string.csv-spec[tag=mv_concat-to_string]
  30. ----
  31. [%header.monospaced.styled,format=dsv,separator=|]
  32. |===
  33. include::{esql-specs}/string.csv-spec[tag=mv_concat-to_string-result]
  34. |===