TD_Pivoting Syntax | Pivoting - TD_Pivoting Syntax - Analytics Database

TD_Pivoting (
  ON { table | view | (query) } AS InputTable PARTITION BY partition_column [,...] [ ORDER BY order_column [,...] ]
  USING
  PartitionColumns({'partition_column' | partition_column_range} [,...])
  TargetColumns({'target_column' | target_column_range} [,...])
  [ Accumulate({'accumulate_column' | accumulate_column_range} [,...]) ]
{
    [ RowsPerPartition (rows_per_partition) ]
 |
    [ PivotColumn('pivot_column') ]
    [ PivotKeys('pivot_key' [,...]) ]
    [ PivotKeysAlias('pivot_key_alias' [,...]) ]
    [ DefaultPivotValues ('default_pivot_value' [,...]) ]
}
  [ Aggregation({'{CONCAT|UNIQUE_CONCAT|SUM|MIN|MAX|AVG}' | 
                 'ColumnName:{CONCAT|UNIQUE_CONCAT|SUM|MIN|MAX|AVG}' [,...]}) ]
  [ Delimiters('single_char' | 'ColumnName:single_char' [,...]) ]
  [ CombinedColumnSizes(size_value | 'ColumnName:size_value' [,...]) ]
  [ TruncateColumns({'truncate_column' | truncate_column_range} [,...]) ]
  [ OutputColumnNames('output_column_name' [,...]) ]
)