Pack

Reverse of the unpack function. Packs data across several columns into a single data column.

Options

Accumulate: Specifies the input table columns to copy to the output table. By default, the function copies no input table columns to the output table.
Colcast: Used to get better elapsed times with use cases involving numeric columns to be packed.
Delimiter: Specifies the delimiter (a string) that separates the virtual columns in the packed data. The default delimiter is comma (,).
IncludeColumnName: Specifies whether to label each virtual column value with its column name (making the virtual column 'input_column:value'). The default value is 'true'.
OutputColumn: Specifies the name to give to the packed output column.
Output Schema: Output Schema, if Volatile is true then use user login as the schema.
Output Table: Output Table
VAL Location: VAL Location
TargetColumns: Specifies the names of the input columns to pack into a single output column. These names become the column names of the virtual columns. By default, all input table columns are packed into a single output column. If you specify this argument, but do not specify all input table columns, the function copies the unspecified input tablecolumns to the output table.
Volatile: Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.