interface PivotOperationProperty

Language	Type name
.NET	`Amazon.CDK.Mixins.Preview.AWS.QuickSight.Mixins.CfnDataSetPropsMixin.PivotOperationProperty`
Go	`github.com/aws/aws-cdk-go/awscdkmixinspreview/v2/awsquicksight/mixins#CfnDataSetPropsMixin_PivotOperationProperty`
Java	`software.amazon.awscdk.mixins.preview.services.quicksight.mixins.CfnDataSetPropsMixin.PivotOperationProperty`
Python	`aws_cdk.mixins_preview.aws_quicksight.mixins.CfnDataSetPropsMixin.PivotOperationProperty`
TypeScript	`@aws-cdk/mixins-preview` » `aws_quicksight` » `mixins` » `CfnDataSetPropsMixin` » `PivotOperationProperty`

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

Example

// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { mixins as quicksight_mixins } from '@aws-cdk/mixins-preview/aws-quicksight';
const pivotOperationProperty: quicksight_mixins.CfnDataSetPropsMixin.PivotOperationProperty = {
  alias: 'alias',
  groupByColumnNames: ['groupByColumnNames'],
  pivotConfiguration: {
    labelColumnName: 'labelColumnName',
    pivotedLabels: [{
      labelName: 'labelName',
      newColumnId: 'newColumnId',
      newColumnName: 'newColumnName',
    }],
  },
  source: {
    columnIdMappings: [{
      sourceColumnId: 'sourceColumnId',
      targetColumnId: 'targetColumnId',
    }],
    transformOperationId: 'transformOperationId',
  },
  valueColumnConfiguration: {
    aggregationFunction: {
      listAggregation: {
        distinct: false,
        inputColumnName: 'inputColumnName',
        separator: 'separator',
      },
      percentileAggregation: {
        inputColumnName: 'inputColumnName',
        percentileValue: 123,
      },
      simpleAggregation: {
        functionType: 'functionType',
        inputColumnName: 'inputColumnName',
      },
    },
  },
};

Properties

Name	Type	Description
alias?	`string`	Alias for this operation.
groupByColumnNames?	`string[]`	The list of column names to group by when performing the pivot operation.
pivotConfiguration?	`IResolvable` `\|` `PivotConfigurationProperty`	Configuration that specifies which labels to pivot and how to structure the resulting columns.
source?	`IResolvable` `\|` `TransformOperationSourceProperty`	The source transform operation that provides input data for pivoting.
valueColumnConfiguration?	`IResolvable` `\|` `ValueColumnConfigurationProperty`	Configuration for how to aggregate values when multiple rows map to the same pivoted column.

alias?

Type: string (optional)

Alias for this operation.

groupByColumnNames?

Type: string[] (optional)

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

pivotConfiguration?

Type: IResolvable | PivotConfigurationProperty (optional)

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

source?

Type: IResolvable | TransformOperationSourceProperty (optional)

The source transform operation that provides input data for pivoting.

valueColumnConfiguration?

Type: IResolvable | ValueColumnConfigurationProperty (optional)

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

AWS CDK

2.233.0