mv_expand.md 544 B

serverless: preview
stack: preview

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

Syntax

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 SORTs. To guarantee a certain ordering, place a SORT after any MV_EXPANDs. ::::

Example

:::{include} ../examples/mv_expand.csv-spec/simple.md :::