- Unpivot
- Specifies the names of the unpivot columns—the input columns to unpivot (convert to rows).
- Accumulate
- Specifies the names of input columns—other than unpivot columns—to copy to the output table. You must specify these columns in the same order that they appear in the input table. No accumulate_column can be an unpivot column.
- InputTypes
- [Optional] Specifies the data types of the unpivoted values in the output table. Default: 'false' (for each unpivoted column, the function outputs the values in a single VARCHAR column).
If you specify 'true', instead of one column for all attribute values, the output table includes three columns (_long, _double, and _str). The unpivoted value appears in the column corresponding to the value’s data type in the input table.
- AttributeColumn
- [Optional] Specifies the name of the unpivoted attribute column in the output table. Default: 'attribute'.
- ValueColumn
- Specifies the name of the unpivoted value column in the output table. Default: 'value'.