This is the new Amazon CloudFormation Template Reference Guide. Please update your bookmarks and links. For help getting started with CloudFormation, see the Amazon CloudFormation User Guide.
AWS::QuickSight::DataSet UnpivotOperation
A transform operation that converts columns into rows, normalizing the data structure.
Syntax
To declare this entity in your Amazon CloudFormation template, use the following syntax:
JSON
{ "Alias" :String, "ColumnsToUnpivot" :[ ColumnToUnpivot, ... ], "Source" :TransformOperationSource, "UnpivotedLabelColumnId" :String, "UnpivotedLabelColumnName" :String, "UnpivotedValueColumnId" :String, "UnpivotedValueColumnName" :String}
YAML
Alias:StringColumnsToUnpivot:- ColumnToUnpivotSource:TransformOperationSourceUnpivotedLabelColumnId:StringUnpivotedLabelColumnName:StringUnpivotedValueColumnId:StringUnpivotedValueColumnName:String
Properties
Alias-
Alias for this operation.
Required: Yes
Type: String
Minimum:
1Maximum:
64Update requires: No interruption
ColumnsToUnpivot-
The list of columns to unpivot from the source data.
Required: Yes
Type: Array of ColumnToUnpivot
Minimum:
0Maximum:
100Update requires: No interruption
Source-
The source transform operation that provides input data for unpivoting.
Required: Yes
Type: TransformOperationSource
Update requires: No interruption
UnpivotedLabelColumnId-
A unique identifier for the new column that will contain the unpivoted column names.
Required: Yes
Type: String
Minimum:
1Maximum:
64Update requires: No interruption
UnpivotedLabelColumnName-
The name for the new column that will contain the unpivoted column names.
Required: Yes
Type: String
Minimum:
1Maximum:
127Update requires: No interruption
UnpivotedValueColumnId-
A unique identifier for the new column that will contain the unpivoted values.
Required: Yes
Type: String
Minimum:
1Maximum:
64Update requires: No interruption
UnpivotedValueColumnName-
The name for the new column that will contain the unpivoted values.
Required: Yes
Type: String
Minimum:
1Maximum:
127Update requires: No interruption