UnpivotOperation
A transform operation that converts columns into rows, normalizing the data structure.
Contents
Note
In the following list, the required parameters are described first.
- Alias
-
Alias for this operation.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 64.
Required: Yes
- ColumnsToUnpivot
-
The list of columns to unpivot from the source data.
Type: Array of ColumnToUnpivot objects
Array Members: Minimum number of 0 items. Maximum number of 100 items.
Required: Yes
- Source
-
The source transform operation that provides input data for unpivoting.
Type: TransformOperationSource object
Required: Yes
- UnpivotedLabelColumnId
-
A unique identifier for the new column that will contain the unpivoted column names.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 64.
Required: Yes
- UnpivotedLabelColumnName
-
The name for the new column that will contain the unpivoted column names.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 128.
Required: Yes
- UnpivotedValueColumnId
-
A unique identifier for the new column that will contain the unpivoted values.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 64.
Required: Yes
- UnpivotedValueColumnName
-
The name for the new column that will contain the unpivoted values.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 128.
Required: Yes
See Also
For more information about using this API in one of the language-specific Amazon SDKs, see the following: