Class CfnDataSet.PivotOperationProperty

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

Inheritance

object

CfnDataSet.PivotOperationProperty

Implements

CfnDataSet.IPivotOperationProperty

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Namespace: Amazon.CDK.AWS.QuickSight

Assembly: Amazon.CDK.Lib.dll

Syntax (csharp)

public class CfnDataSet.PivotOperationProperty : CfnDataSet.IPivotOperationProperty

Syntax (vb)

Public Class CfnDataSet.PivotOperationProperty Implements CfnDataSet.IPivotOperationProperty

Remarks

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

ExampleMetadata: fixture=_generated

Examples

// The code below shows an example of how to instantiate this type.
             // The values are placeholders you should change.
             using Amazon.CDK.AWS.QuickSight;

             var pivotOperationProperty = new PivotOperationProperty {
                 Alias = "alias",
                 PivotConfiguration = new PivotConfigurationProperty {
                     PivotedLabels = new [] { new PivotedLabelProperty {
                         LabelName = "labelName",
                         NewColumnId = "newColumnId",
                         NewColumnName = "newColumnName"
                     } },

                     // the properties below are optional
                     LabelColumnName = "labelColumnName"
                 },
                 Source = new TransformOperationSourceProperty {
                     TransformOperationId = "transformOperationId",

                     // the properties below are optional
                     ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                         SourceColumnId = "sourceColumnId",
                         TargetColumnId = "targetColumnId"
                     } }
                 },
                 ValueColumnConfiguration = new ValueColumnConfigurationProperty {
                     AggregationFunction = new DataPrepAggregationFunctionProperty {
                         ListAggregation = new DataPrepListAggregationFunctionProperty {
                             Distinct = false,
                             Separator = "separator",

                             // the properties below are optional
                             InputColumnName = "inputColumnName"
                         },
                         PercentileAggregation = new DataPrepPercentileAggregationFunctionProperty {
                             PercentileValue = 123,

                             // the properties below are optional
                             InputColumnName = "inputColumnName"
                         },
                         SimpleAggregation = new DataPrepSimpleAggregationFunctionProperty {
                             FunctionType = "functionType",

                             // the properties below are optional
                             InputColumnName = "inputColumnName"
                         }
                     }
                 },

                 // the properties below are optional
                 GroupByColumnNames = new [] { "groupByColumnNames" }
             };

Synopsis

Constructors

PivotOperationProperty()

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

Properties

Alias	Alias for this operation.
GroupByColumnNames	The list of column names to group by when performing the pivot operation.
PivotConfiguration	Configuration that specifies which labels to pivot and how to structure the resulting columns.
Source	The source transform operation that provides input data for pivoting.
ValueColumnConfiguration	Configuration for how to aggregate values when multiple rows map to the same pivoted column.

Constructors

PivotOperationProperty()

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

public PivotOperationProperty()

Remarks

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

ExampleMetadata: fixture=_generated

Examples

// The code below shows an example of how to instantiate this type.
             // The values are placeholders you should change.
             using Amazon.CDK.AWS.QuickSight;

             var pivotOperationProperty = new PivotOperationProperty {
                 Alias = "alias",
                 PivotConfiguration = new PivotConfigurationProperty {
                     PivotedLabels = new [] { new PivotedLabelProperty {
                         LabelName = "labelName",
                         NewColumnId = "newColumnId",
                         NewColumnName = "newColumnName"
                     } },

                     // the properties below are optional
                     LabelColumnName = "labelColumnName"
                 },
                 Source = new TransformOperationSourceProperty {
                     TransformOperationId = "transformOperationId",

                     // the properties below are optional
                     ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                         SourceColumnId = "sourceColumnId",
                         TargetColumnId = "targetColumnId"
                     } }
                 },
                 ValueColumnConfiguration = new ValueColumnConfigurationProperty {
                     AggregationFunction = new DataPrepAggregationFunctionProperty {
                         ListAggregation = new DataPrepListAggregationFunctionProperty {
                             Distinct = false,
                             Separator = "separator",

                             // the properties below are optional
                             InputColumnName = "inputColumnName"
                         },
                         PercentileAggregation = new DataPrepPercentileAggregationFunctionProperty {
                             PercentileValue = 123,

                             // the properties below are optional
                             InputColumnName = "inputColumnName"
                         },
                         SimpleAggregation = new DataPrepSimpleAggregationFunctionProperty {
                             FunctionType = "functionType",

                             // the properties below are optional
                             InputColumnName = "inputColumnName"
                         }
                     }
                 },

                 // the properties below are optional
                 GroupByColumnNames = new [] { "groupByColumnNames" }
             };

Properties

Alias

Alias for this operation.

public string Alias { get; set; }

Property Value

string

Remarks

See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-pivotoperation.html#cfn-quicksight-dataset-pivotoperation-alias

GroupByColumnNames

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

public string[]? GroupByColumnNames { get; set; }

Property Value

string[]

Remarks

See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-pivotoperation.html#cfn-quicksight-dataset-pivotoperation-groupbycolumnnames

PivotConfiguration

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

public object PivotConfiguration { get; set; }

Property Value

object

Remarks

See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-pivotoperation.html#cfn-quicksight-dataset-pivotoperation-pivotconfiguration

Type union: either IResolvable or CfnDataSet.IPivotConfigurationProperty

Source

The source transform operation that provides input data for pivoting.

public object Source { get; set; }

Property Value

object

Remarks

See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-pivotoperation.html#cfn-quicksight-dataset-pivotoperation-source

Type union: either IResolvable or CfnDataSet.ITransformOperationSourceProperty

ValueColumnConfiguration

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

public object ValueColumnConfiguration { get; set; }