Class CfnDataSetPropsMixin.TransformStepProperty
A step in data preparation that performs a specific operation on the data.
Implements
Inherited Members
Namespace: Amazon.CDK.Mixins.Preview.AWS.QuickSight.Mixins
Assembly: Amazon.CDK.Mixins.Preview.dll
Syntax (csharp)
public class CfnDataSetPropsMixin.TransformStepProperty : CfnDataSetPropsMixin.ITransformStepProperty
Syntax (vb)
Public Class CfnDataSetPropsMixin.TransformStepProperty Implements CfnDataSetPropsMixin.ITransformStepProperty
Remarks
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.Mixins.Preview.AWS.QuickSight.Mixins;
var transformStepProperty = new TransformStepProperty {
AggregateStep = new AggregateOperationProperty {
Aggregations = new [] { new AggregationProperty {
AggregationFunction = new DataPrepAggregationFunctionProperty {
ListAggregation = new DataPrepListAggregationFunctionProperty {
Distinct = false,
InputColumnName = "inputColumnName",
Separator = "separator"
},
PercentileAggregation = new DataPrepPercentileAggregationFunctionProperty {
InputColumnName = "inputColumnName",
PercentileValue = 123
},
SimpleAggregation = new DataPrepSimpleAggregationFunctionProperty {
FunctionType = "functionType",
InputColumnName = "inputColumnName"
}
},
NewColumnId = "newColumnId",
NewColumnName = "newColumnName"
} },
Alias = "alias",
GroupByColumnNames = new [] { "groupByColumnNames" },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
AppendStep = new AppendOperationProperty {
Alias = "alias",
AppendedColumns = new [] { new AppendedColumnProperty {
ColumnName = "columnName",
NewColumnId = "newColumnId"
} },
FirstSource = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
},
SecondSource = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
CastColumnTypesStep = new CastColumnTypesOperationProperty {
Alias = "alias",
CastColumnTypeOperations = new [] { new CastColumnTypeOperationProperty {
ColumnName = "columnName",
Format = "format",
NewColumnType = "newColumnType",
SubType = "subType"
} },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
CreateColumnsStep = new CreateColumnsOperationProperty {
Alias = "alias",
Columns = new [] { new CalculatedColumnProperty {
ColumnId = "columnId",
ColumnName = "columnName",
Expression = "expression"
} },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
FiltersStep = new FiltersOperationProperty {
Alias = "alias",
FilterOperations = new [] { new FilterOperationProperty {
ConditionExpression = "conditionExpression",
DateFilterCondition = new DataSetDateFilterConditionProperty {
ColumnName = "columnName",
ComparisonFilterCondition = new DataSetDateComparisonFilterConditionProperty {
Operator = "operator",
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",
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",
Value = new DataSetStringFilterValueProperty {
StaticValue = "staticValue"
}
},
ListFilterCondition = new DataSetStringListFilterConditionProperty {
Operator = "operator",
Values = new DataSetStringListFilterValueProperty {
StaticValues = new [] { "staticValues" }
}
}
}
} },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
ImportTableStep = new ImportTableOperationProperty {
Alias = "alias",
Source = new ImportTableOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
SourceTableId = "sourceTableId"
}
},
JoinStep = new JoinOperationProperty {
Alias = "alias",
LeftOperand = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
},
LeftOperandProperties = new JoinOperandPropertiesProperty {
OutputColumnNameOverrides = new [] { new OutputColumnNameOverrideProperty {
OutputColumnName = "outputColumnName",
SourceColumnName = "sourceColumnName"
} }
},
OnClause = "onClause",
RightOperand = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
},
RightOperandProperties = new JoinOperandPropertiesProperty {
OutputColumnNameOverrides = new [] { new OutputColumnNameOverrideProperty {
OutputColumnName = "outputColumnName",
SourceColumnName = "sourceColumnName"
} }
},
Type = "type"
},
PivotStep = new PivotOperationProperty {
Alias = "alias",
GroupByColumnNames = new [] { "groupByColumnNames" },
PivotConfiguration = new PivotConfigurationProperty {
LabelColumnName = "labelColumnName",
PivotedLabels = new [] { new PivotedLabelProperty {
LabelName = "labelName",
NewColumnId = "newColumnId",
NewColumnName = "newColumnName"
} }
},
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
},
ValueColumnConfiguration = new ValueColumnConfigurationProperty {
AggregationFunction = new DataPrepAggregationFunctionProperty {
ListAggregation = new DataPrepListAggregationFunctionProperty {
Distinct = false,
InputColumnName = "inputColumnName",
Separator = "separator"
},
PercentileAggregation = new DataPrepPercentileAggregationFunctionProperty {
InputColumnName = "inputColumnName",
PercentileValue = 123
},
SimpleAggregation = new DataPrepSimpleAggregationFunctionProperty {
FunctionType = "functionType",
InputColumnName = "inputColumnName"
}
}
}
},
ProjectStep = new ProjectOperationProperty {
Alias = "alias",
ProjectedColumns = new [] { "projectedColumns" },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
RenameColumnsStep = new RenameColumnsOperationProperty {
Alias = "alias",
RenameColumnOperations = new [] { new RenameColumnOperationProperty {
ColumnName = "columnName",
NewColumnName = "newColumnName"
} },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
UnpivotStep = new UnpivotOperationProperty {
Alias = "alias",
ColumnsToUnpivot = new [] { new ColumnToUnpivotProperty {
ColumnName = "columnName",
NewValue = "newValue"
} },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
},
UnpivotedLabelColumnId = "unpivotedLabelColumnId",
UnpivotedLabelColumnName = "unpivotedLabelColumnName",
UnpivotedValueColumnId = "unpivotedValueColumnId",
UnpivotedValueColumnName = "unpivotedValueColumnName"
}
};
Synopsis
Constructors
| TransformStepProperty() | A step in data preparation that performs a specific operation on the data. |
Properties
| AggregateStep | A transform step that groups data and applies aggregation functions to calculate summary values. |
| AppendStep | A transform step that combines rows from multiple sources by stacking them vertically. |
| CastColumnTypesStep | A transform step that changes the data types of one or more columns. |
| CreateColumnsStep | <p>A transform operation that creates calculated columns. |
| FiltersStep | A transform step that applies filter conditions. |
| ImportTableStep | A transform step that brings data from a source table. |
| JoinStep | A transform step that combines data from two sources based on specified join conditions. |
| PivotStep | A transform step that converts row values into columns to reshape the data structure. |
| ProjectStep | <p>A transform operation that projects columns. |
| RenameColumnsStep | A transform step that changes the names of one or more columns. |
| UnpivotStep | A transform step that converts columns into rows to normalize the data structure. |
Constructors
TransformStepProperty()
A step in data preparation that performs a specific operation on the data.
public TransformStepProperty()
Remarks
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.Mixins.Preview.AWS.QuickSight.Mixins;
var transformStepProperty = new TransformStepProperty {
AggregateStep = new AggregateOperationProperty {
Aggregations = new [] { new AggregationProperty {
AggregationFunction = new DataPrepAggregationFunctionProperty {
ListAggregation = new DataPrepListAggregationFunctionProperty {
Distinct = false,
InputColumnName = "inputColumnName",
Separator = "separator"
},
PercentileAggregation = new DataPrepPercentileAggregationFunctionProperty {
InputColumnName = "inputColumnName",
PercentileValue = 123
},
SimpleAggregation = new DataPrepSimpleAggregationFunctionProperty {
FunctionType = "functionType",
InputColumnName = "inputColumnName"
}
},
NewColumnId = "newColumnId",
NewColumnName = "newColumnName"
} },
Alias = "alias",
GroupByColumnNames = new [] { "groupByColumnNames" },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
AppendStep = new AppendOperationProperty {
Alias = "alias",
AppendedColumns = new [] { new AppendedColumnProperty {
ColumnName = "columnName",
NewColumnId = "newColumnId"
} },
FirstSource = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
},
SecondSource = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
CastColumnTypesStep = new CastColumnTypesOperationProperty {
Alias = "alias",
CastColumnTypeOperations = new [] { new CastColumnTypeOperationProperty {
ColumnName = "columnName",
Format = "format",
NewColumnType = "newColumnType",
SubType = "subType"
} },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
CreateColumnsStep = new CreateColumnsOperationProperty {
Alias = "alias",
Columns = new [] { new CalculatedColumnProperty {
ColumnId = "columnId",
ColumnName = "columnName",
Expression = "expression"
} },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
FiltersStep = new FiltersOperationProperty {
Alias = "alias",
FilterOperations = new [] { new FilterOperationProperty {
ConditionExpression = "conditionExpression",
DateFilterCondition = new DataSetDateFilterConditionProperty {
ColumnName = "columnName",
ComparisonFilterCondition = new DataSetDateComparisonFilterConditionProperty {
Operator = "operator",
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",
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",
Value = new DataSetStringFilterValueProperty {
StaticValue = "staticValue"
}
},
ListFilterCondition = new DataSetStringListFilterConditionProperty {
Operator = "operator",
Values = new DataSetStringListFilterValueProperty {
StaticValues = new [] { "staticValues" }
}
}
}
} },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
ImportTableStep = new ImportTableOperationProperty {
Alias = "alias",
Source = new ImportTableOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
SourceTableId = "sourceTableId"
}
},
JoinStep = new JoinOperationProperty {
Alias = "alias",
LeftOperand = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
},
LeftOperandProperties = new JoinOperandPropertiesProperty {
OutputColumnNameOverrides = new [] { new OutputColumnNameOverrideProperty {
OutputColumnName = "outputColumnName",
SourceColumnName = "sourceColumnName"
} }
},
OnClause = "onClause",
RightOperand = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
},
RightOperandProperties = new JoinOperandPropertiesProperty {
OutputColumnNameOverrides = new [] { new OutputColumnNameOverrideProperty {
OutputColumnName = "outputColumnName",
SourceColumnName = "sourceColumnName"
} }
},
Type = "type"
},
PivotStep = new PivotOperationProperty {
Alias = "alias",
GroupByColumnNames = new [] { "groupByColumnNames" },
PivotConfiguration = new PivotConfigurationProperty {
LabelColumnName = "labelColumnName",
PivotedLabels = new [] { new PivotedLabelProperty {
LabelName = "labelName",
NewColumnId = "newColumnId",
NewColumnName = "newColumnName"
} }
},
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
},
ValueColumnConfiguration = new ValueColumnConfigurationProperty {
AggregationFunction = new DataPrepAggregationFunctionProperty {
ListAggregation = new DataPrepListAggregationFunctionProperty {
Distinct = false,
InputColumnName = "inputColumnName",
Separator = "separator"
},
PercentileAggregation = new DataPrepPercentileAggregationFunctionProperty {
InputColumnName = "inputColumnName",
PercentileValue = 123
},
SimpleAggregation = new DataPrepSimpleAggregationFunctionProperty {
FunctionType = "functionType",
InputColumnName = "inputColumnName"
}
}
}
},
ProjectStep = new ProjectOperationProperty {
Alias = "alias",
ProjectedColumns = new [] { "projectedColumns" },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
RenameColumnsStep = new RenameColumnsOperationProperty {
Alias = "alias",
RenameColumnOperations = new [] { new RenameColumnOperationProperty {
ColumnName = "columnName",
NewColumnName = "newColumnName"
} },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
}
},
UnpivotStep = new UnpivotOperationProperty {
Alias = "alias",
ColumnsToUnpivot = new [] { new ColumnToUnpivotProperty {
ColumnName = "columnName",
NewValue = "newValue"
} },
Source = new TransformOperationSourceProperty {
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} },
TransformOperationId = "transformOperationId"
},
UnpivotedLabelColumnId = "unpivotedLabelColumnId",
UnpivotedLabelColumnName = "unpivotedLabelColumnName",
UnpivotedValueColumnId = "unpivotedValueColumnId",
UnpivotedValueColumnName = "unpivotedValueColumnName"
}
};
Properties
AggregateStep
A transform step that groups data and applies aggregation functions to calculate summary values.
public object? AggregateStep { get; set; }
Property Value
Remarks
AppendStep
A transform step that combines rows from multiple sources by stacking them vertically.
public object? AppendStep { get; set; }
Property Value
Remarks
CastColumnTypesStep
A transform step that changes the data types of one or more columns.
public object? CastColumnTypesStep { get; set; }
Property Value
Remarks
CreateColumnsStep
<p>A transform operation that creates calculated columns.
public object? CreateColumnsStep { get; set; }
Property Value
Remarks
Columns created in one such operation form a lexical closure.</p>
Type union: either IResolvable or CfnDataSetPropsMixin.ICreateColumnsOperationProperty
FiltersStep
A transform step that applies filter conditions.
public object? FiltersStep { get; set; }
Property Value
Remarks
ImportTableStep
A transform step that brings data from a source table.
public object? ImportTableStep { get; set; }
Property Value
Remarks
JoinStep
A transform step that combines data from two sources based on specified join conditions.
public object? JoinStep { get; set; }
Property Value
Remarks
PivotStep
A transform step that converts row values into columns to reshape the data structure.
public object? PivotStep { get; set; }
Property Value
Remarks
ProjectStep
<p>A transform operation that projects columns.
public object? ProjectStep { get; set; }
Property Value
Remarks
Operations that come after a projection can only refer to projected columns.</p>
Type union: either IResolvable or CfnDataSetPropsMixin.IProjectOperationProperty
RenameColumnsStep
A transform step that changes the names of one or more columns.
public object? RenameColumnsStep { get; set; }
Property Value
Remarks
UnpivotStep
A transform step that converts columns into rows to normalize the data structure.
public object? UnpivotStep { get; set; }