Class CfnDataSet.TransformOperationProperty

A data transformation on a logical table.

Inheritance

object

CfnDataSet.TransformOperationProperty

Implements

CfnDataSet.ITransformOperationProperty

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.TransformOperationProperty : CfnDataSet.ITransformOperationProperty

Syntax (vb)

Public Class CfnDataSet.TransformOperationProperty Implements CfnDataSet.ITransformOperationProperty

Remarks

This is a variant type structure. For this structure to be valid, only one of the attributes can be non-null.

See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-transformoperation.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 transformOperationProperty = new TransformOperationProperty {
                 CastColumnTypeOperation = new CastColumnTypeOperationProperty {
                     ColumnName = "columnName",
                     NewColumnType = "newColumnType",

                     // the properties below are optional
                     Format = "format",
                     SubType = "subType"
                 },
                 CreateColumnsOperation = new CreateColumnsOperationProperty {
                     Columns = new [] { new CalculatedColumnProperty {
                         ColumnId = "columnId",
                         ColumnName = "columnName",
                         Expression = "expression"
                     } },

                     // the properties below are optional
                     Alias = "alias",
                     Source = new TransformOperationSourceProperty {
                         TransformOperationId = "transformOperationId",

                         // the properties below are optional
                         ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                             SourceColumnId = "sourceColumnId",
                             TargetColumnId = "targetColumnId"
                         } }
                     }
                 },
                 FilterOperation = new FilterOperationProperty {
                     ConditionExpression = "conditionExpression",
                     DateFilterCondition = new DataSetDateFilterConditionProperty {
                         ColumnName = "columnName",
                         ComparisonFilterCondition = new DataSetDateComparisonFilterConditionProperty {
                             Operator = "operator",

                             // the properties below are optional
                             Value = new DataSetDateFilterValueProperty {
                                 StaticValue = "staticValue"
                             }
                         },
                         RangeFilterCondition = new DataSetDateRangeFilterConditionProperty {
                             IncludeMaximum = false,
                             IncludeMinimum = false,
                             RangeMaximum = new DataSetDateFilterValueProperty {
                                 StaticValue = "staticValue"
                             },
                             RangeMinimum = new DataSetDateFilterValueProperty {
                                 StaticValue = "staticValue"
                             }
                         }
                     },
                     NumericFilterCondition = new DataSetNumericFilterConditionProperty {
                         ColumnName = "columnName",
                         ComparisonFilterCondition = new DataSetNumericComparisonFilterConditionProperty {
                             Operator = "operator",

                             // the properties below are optional
                             Value = new DataSetNumericFilterValueProperty {
                                 StaticValue = 123
                             }
                         },
                         RangeFilterCondition = new DataSetNumericRangeFilterConditionProperty {
                             IncludeMaximum = false,
                             IncludeMinimum = false,
                             RangeMaximum = new DataSetNumericFilterValueProperty {
                                 StaticValue = 123
                             },
                             RangeMinimum = new DataSetNumericFilterValueProperty {
                                 StaticValue = 123
                             }
                         }
                     },
                     StringFilterCondition = new DataSetStringFilterConditionProperty {
                         ColumnName = "columnName",
                         ComparisonFilterCondition = new DataSetStringComparisonFilterConditionProperty {
                             Operator = "operator",

                             // the properties below are optional
                             Value = new DataSetStringFilterValueProperty {
                                 StaticValue = "staticValue"
                             }
                         },
                         ListFilterCondition = new DataSetStringListFilterConditionProperty {
                             Operator = "operator",

                             // the properties below are optional
                             Values = new DataSetStringListFilterValueProperty {
                                 StaticValues = new [] { "staticValues" }
                             }
                         }
                     }
                 },
                 OverrideDatasetParameterOperation = new OverrideDatasetParameterOperationProperty {
                     ParameterName = "parameterName",

                     // the properties below are optional
                     NewDefaultValues = new NewDefaultValuesProperty {
                         DateTimeStaticValues = new [] { "dateTimeStaticValues" },
                         DecimalStaticValues = new [] { 123 },
                         IntegerStaticValues = new [] { 123 },
                         StringStaticValues = new [] { "stringStaticValues" }
                     },
                     NewParameterName = "newParameterName"
                 },
                 ProjectOperation = new ProjectOperationProperty {
                     Alias = "alias",
                     ProjectedColumns = new [] { "projectedColumns" },
                     Source = new TransformOperationSourceProperty {
                         TransformOperationId = "transformOperationId",

                         // the properties below are optional
                         ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                             SourceColumnId = "sourceColumnId",
                             TargetColumnId = "targetColumnId"
                         } }
                     }
                 },
                 RenameColumnOperation = new RenameColumnOperationProperty {
                     ColumnName = "columnName",
                     NewColumnName = "newColumnName"
                 },
                 TagColumnOperation = new TagColumnOperationProperty {
                     ColumnName = "columnName",
                     Tags = new [] { new ColumnTagProperty {
                         ColumnDescription = new ColumnDescriptionProperty {
                             Text = "text"
                         },
                         ColumnGeographicRole = "columnGeographicRole"
                     } }
                 },
                 UntagColumnOperation = new UntagColumnOperationProperty {
                     ColumnName = "columnName",
                     TagNames = new [] { "tagNames" }
                 }
             };

Synopsis

Constructors

TransformOperationProperty()

A data transformation on a logical table.

Properties

CastColumnTypeOperation	A transform operation that casts a column to a different type.
CreateColumnsOperation	An operation that creates calculated columns.
FilterOperation	An operation that filters rows based on some condition.
OverrideDatasetParameterOperation	A transform operation that overrides the dataset parameter values that are defined in another dataset.
ProjectOperation	An operation that projects columns.
RenameColumnOperation	An operation that renames a column.
TagColumnOperation	An operation that tags a column with additional information.
UntagColumnOperation	<p>A transform operation that removes tags associated with a column.</p>.

Constructors

TransformOperationProperty()

A data transformation on a logical table.

public TransformOperationProperty()

Remarks

This is a variant type structure. For this structure to be valid, only one of the attributes can be non-null.

See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-transformoperation.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 transformOperationProperty = new TransformOperationProperty {
                 CastColumnTypeOperation = new CastColumnTypeOperationProperty {
                     ColumnName = "columnName",
                     NewColumnType = "newColumnType",

                     // the properties below are optional
                     Format = "format",
                     SubType = "subType"
                 },
                 CreateColumnsOperation = new CreateColumnsOperationProperty {
                     Columns = new [] { new CalculatedColumnProperty {
                         ColumnId = "columnId",
                         ColumnName = "columnName",
                         Expression = "expression"
                     } },

                     // the properties below are optional
                     Alias = "alias",
                     Source = new TransformOperationSourceProperty {
                         TransformOperationId = "transformOperationId",

                         // the properties below are optional
                         ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                             SourceColumnId = "sourceColumnId",
                             TargetColumnId = "targetColumnId"
                         } }
                     }
                 },
                 FilterOperation = new FilterOperationProperty {
                     ConditionExpression = "conditionExpression",
                     DateFilterCondition = new DataSetDateFilterConditionProperty {
                         ColumnName = "columnName",
                         ComparisonFilterCondition = new DataSetDateComparisonFilterConditionProperty {
                             Operator = "operator",

                             // the properties below are optional
                             Value = new DataSetDateFilterValueProperty {
                                 StaticValue = "staticValue"
                             }
                         },
                         RangeFilterCondition = new DataSetDateRangeFilterConditionProperty {
                             IncludeMaximum = false,
                             IncludeMinimum = false,
                             RangeMaximum = new DataSetDateFilterValueProperty {
                                 StaticValue = "staticValue"
                             },
                             RangeMinimum = new DataSetDateFilterValueProperty {
                                 StaticValue = "staticValue"
                             }
                         }
                     },
                     NumericFilterCondition = new DataSetNumericFilterConditionProperty {
                         ColumnName = "columnName",
                         ComparisonFilterCondition = new DataSetNumericComparisonFilterConditionProperty {
                             Operator = "operator",

                             // the properties below are optional
                             Value = new DataSetNumericFilterValueProperty {
                                 StaticValue = 123
                             }
                         },
                         RangeFilterCondition = new DataSetNumericRangeFilterConditionProperty {
                             IncludeMaximum = false,
                             IncludeMinimum = false,
                             RangeMaximum = new DataSetNumericFilterValueProperty {
                                 StaticValue = 123
                             },
                             RangeMinimum = new DataSetNumericFilterValueProperty {
                                 StaticValue = 123
                             }
                         }
                     },
                     StringFilterCondition = new DataSetStringFilterConditionProperty {
                         ColumnName = "columnName",
                         ComparisonFilterCondition = new DataSetStringComparisonFilterConditionProperty {
                             Operator = "operator",

                             // the properties below are optional
                             Value = new DataSetStringFilterValueProperty {
                                 StaticValue = "staticValue"
                             }
                         },
                         ListFilterCondition = new DataSetStringListFilterConditionProperty {
                             Operator = "operator",

                             // the properties below are optional
                             Values = new DataSetStringListFilterValueProperty {
                                 StaticValues = new [] { "staticValues" }
                             }
                         }
                     }
                 },
                 OverrideDatasetParameterOperation = new OverrideDatasetParameterOperationProperty {
                     ParameterName = "parameterName",

                     // the properties below are optional
                     NewDefaultValues = new NewDefaultValuesProperty {
                         DateTimeStaticValues = new [] { "dateTimeStaticValues" },
                         DecimalStaticValues = new [] { 123 },
                         IntegerStaticValues = new [] { 123 },
                         StringStaticValues = new [] { "stringStaticValues" }
                     },
                     NewParameterName = "newParameterName"
                 },
                 ProjectOperation = new ProjectOperationProperty {
                     Alias = "alias",
                     ProjectedColumns = new [] { "projectedColumns" },
                     Source = new TransformOperationSourceProperty {
                         TransformOperationId = "transformOperationId",

                         // the properties below are optional
                         ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
                             SourceColumnId = "sourceColumnId",
                             TargetColumnId = "targetColumnId"
                         } }
                     }
                 },
                 RenameColumnOperation = new RenameColumnOperationProperty {
                     ColumnName = "columnName",
                     NewColumnName = "newColumnName"
                 },
                 TagColumnOperation = new TagColumnOperationProperty {
                     ColumnName = "columnName",
                     Tags = new [] { new ColumnTagProperty {
                         ColumnDescription = new ColumnDescriptionProperty {
                             Text = "text"
                         },
                         ColumnGeographicRole = "columnGeographicRole"
                     } }
                 },
                 UntagColumnOperation = new UntagColumnOperationProperty {
                     ColumnName = "columnName",
                     TagNames = new [] { "tagNames" }
                 }
             };

Properties

CastColumnTypeOperation

A transform operation that casts a column to a different type.

public object? CastColumnTypeOperation { get; set; }

Property Value

object

Remarks

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

Type union: either IResolvable or CfnDataSet.ICastColumnTypeOperationProperty

CreateColumnsOperation

An operation that creates calculated columns.

public object? CreateColumnsOperation { get; set; }

Property Value

object

Remarks

Columns created in one such operation form a lexical closure.

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

Type union: either IResolvable or CfnDataSet.ICreateColumnsOperationProperty

FilterOperation

An operation that filters rows based on some condition.

public object? FilterOperation { get; set; }

Property Value

object

Remarks

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

Type union: either IResolvable or CfnDataSet.IFilterOperationProperty

OverrideDatasetParameterOperation

A transform operation that overrides the dataset parameter values that are defined in another dataset.

public object? OverrideDatasetParameterOperation { get; set; }

Property Value

object

Remarks

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

Type union: either IResolvable or CfnDataSet.IOverrideDatasetParameterOperationProperty

ProjectOperation

An operation that projects columns.

public object? ProjectOperation { get; set; }

Property Value

object

Remarks

Operations that come after a projection can only refer to projected columns.

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

Type union: either IResolvable or CfnDataSet.IProjectOperationProperty

RenameColumnOperation

An operation that renames a column.

public object? RenameColumnOperation { get; set; }

Property Value

object

Remarks

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

Type union: either IResolvable or CfnDataSet.IRenameColumnOperationProperty

TagColumnOperation

An operation that tags a column with additional information.

public object? TagColumnOperation { get; set; }

Property Value

object

Remarks

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

Type union: either IResolvable or CfnDataSet.ITagColumnOperationProperty

UntagColumnOperation

<p>A transform operation that removes tags associated with a column.</p>.

public object? UntagColumnOperation { get; set; }