elasticsearch/docs/reference/query-languages/esql/_snippets/functions/examples/mv_append.md

% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.

Example

FROM employees
| WHERE emp_no == 10039 OR emp_no == 10040
| SORT emp_no
| EVAL dates = MV_APPEND(birth_date, hire_date)
| KEEP emp_no, birth_date, hire_date, dates

emp_no:integer	birth_date:date	hire_date:date	dates:date
10039	1959-10-01T00:00:00Z	1988-01-19T00:00:00Z	[1959-10-01T00:00:00Z, 1988-01-19T00:00:00Z]
10040	null	1993-02-14T00:00:00Z	null