interface UnpivotOperationProperty

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

A transform operation that converts columns into rows, normalizing the data structure.

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-unpivotoperation.html

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 unpivotOperationProperty: quicksight_mixins.CfnDataSetPropsMixin.UnpivotOperationProperty = {
  alias: 'alias',
  columnsToUnpivot: [{
    columnName: 'columnName',
    newValue: 'newValue',
  }],
  source: {
    columnIdMappings: [{
      sourceColumnId: 'sourceColumnId',
      targetColumnId: 'targetColumnId',
    }],
    transformOperationId: 'transformOperationId',
  },
  unpivotedLabelColumnId: 'unpivotedLabelColumnId',
  unpivotedLabelColumnName: 'unpivotedLabelColumnName',
  unpivotedValueColumnId: 'unpivotedValueColumnId',
  unpivotedValueColumnName: 'unpivotedValueColumnName',
};

Properties

Name	Type	Description
alias?	`string`	Alias for this operation.
columnsToUnpivot?	`IResolvable` `\| (IResolvable` `\|` `ColumnToUnpivotProperty)[]`	The list of columns to unpivot from the source data.
source?	`IResolvable` `\|` `TransformOperationSourceProperty`	The source transform operation that provides input data for unpivoting.
unpivotedLabelColumnId?	`string`	A unique identifier for the new column that will contain the unpivoted column names.
unpivotedLabelColumnName?	`string`	The name for the new column that will contain the unpivoted column names.
unpivotedValueColumnId?	`string`	A unique identifier for the new column that will contain the unpivoted values.
unpivotedValueColumnName?	`string`	The name for the new column that will contain the unpivoted values.