PivotOperation - Amazon Quick Sight
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

PivotOperation

A transform operation that pivots data by converting row values into columns.

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

PivotConfiguration

Configuration that specifies which labels to pivot and how to structure the resulting columns.

Type: PivotConfiguration object

Required: Yes

Source

The source transform operation that provides input data for pivoting.

Type: TransformOperationSource object

Required: Yes

ValueColumnConfiguration

Configuration for how to aggregate values when multiple rows map to the same pivoted column.

Type: ValueColumnConfiguration object

Required: Yes

GroupByColumnNames

The list of column names to group by when performing the pivot operation.

Type: Array of strings

Array Members: Minimum number of 0 items. Maximum number of 128 items.

Length Constraints: Minimum length of 1. Maximum length of 128.

Required: No

See Also

For more information about using this API in one of the language-specific Amazon SDKs, see the following: