- Accumulate
- Specifies the copied columns to the output columns. Accumulate Column values from the last row of the partition will be copied to the output.
- RowsPerPartition
- Use RowsPerPartition when no column contains pivot keys, but you can specify a maximum number of rows in any partition. The function pivots the input rows into this number of columns in the output table. If a partition has fewer than rows_per_partition rows, the function adds NULL values; if a partition has more than rows_per_partition rows, the function omits the extra rows. If you use this argument, you must use the ORDER BY clause to order the input data; otherwise, the contents of the output table columns may vary from run to run. MinValue = 1 MaxValue = 2047, if aggregation is not given If this argument is used with aggregation, then the aggregation will consider rows_per_partition rows for aggregation of the data. MaxValue =INT_MAX, if aggregation is given. Note: RowsPerPartition cannot be used with PivotColumn.Required if you omit both PivotColumn and Aggregation, otherwise ignored.
- PivotColumn
- Specifies the input column name that contains the pivot keys.
PivotColumn cannot be used with RowsPerPartition.
Required if you omit both RowsPerPartition and Aggregation, otherwise ignored.
- PivotKeys
- Specifies the pivot_column values to use as pivot keys. The function ignores rows that contain other pivot_column values.Required if you specify PivotColumn, otherwise ignored.
- PivotKeysAlias
- Specifies exactly one pivot key alias for each pivot_key. The nth pivot_key_alias_value applies to the nth pivot_key.Optional with PivotKeys, otherwise not required.
- DefaultPivotValues
- Specifies exactly one default value for each pivot_key.
- Aggregation
- Specifies the aggregation for the target columns.
- Delimiters
- Specifies the delimiter to use for concatenating the target column values.
- CombinedColumnSizes
- Specifies the concatenated string maximum size.
- TruncateColumns
- Specifies the columns from the target columns for which you want to truncate the concatenated string, if it is longer than the specified size.
- OutputColumnNames
- Specifies the column name to use for the output column.