TransformStepProperty Struct
A step in data preparation that performs a specific operation on the data.
Example
ts
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_quicksight as quicksight } from 'aws-cdk-lib';
const transformStepProperty: quicksight.CfnDataSet.TransformStepProperty = {
aggregateStep: {
aggregations: [{
aggregationFunction: {
listAggregation: {
distinct: false,
separator: 'separator',
// the properties below are optional
inputColumnName: 'inputColumnName',
},
percentileAggregation: {
percentileValue: 123,
// the properties below are optional
inputColumnName: 'inputColumnName',
},
simpleAggregation: {
functionType: 'functionType',
// the properties below are optional
inputColumnName: 'inputColumnName',
},
},
newColumnId: 'newColumnId',
newColumnName: 'newColumnName',
}],
alias: 'alias',
source: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
// the properties below are optional
groupByColumnNames: ['groupByColumnNames'],
},
appendStep: {
alias: 'alias',
appendedColumns: [{
columnName: 'columnName',
newColumnId: 'newColumnId',
}],
// the properties below are optional
firstSource: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
secondSource: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
},
castColumnTypesStep: {
alias: 'alias',
castColumnTypeOperations: [{
columnName: 'columnName',
newColumnType: 'newColumnType',
// the properties below are optional
format: 'format',
subType: 'subType',
}],
source: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
},
createColumnsStep: {
columns: [{
columnId: 'columnId',
columnName: 'columnName',
expression: 'expression',
}],
// the properties below are optional
alias: 'alias',
source: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
},
filtersStep: {
alias: 'alias',
filterOperations: [{
conditionExpression: 'conditionExpression',
dateFilterCondition: {
columnName: 'columnName',
comparisonFilterCondition: {
operator: 'operator',
// the properties below are optional
value: {
staticValue: 'staticValue',
},
},
rangeFilterCondition: {
includeMaximum: false,
includeMinimum: false,
rangeMaximum: {
staticValue: 'staticValue',
},
rangeMinimum: {
staticValue: 'staticValue',
},
},
},
numericFilterCondition: {
columnName: 'columnName',
comparisonFilterCondition: {
operator: 'operator',
// the properties below are optional
value: {
staticValue: 123,
},
},
rangeFilterCondition: {
includeMaximum: false,
includeMinimum: false,
rangeMaximum: {
staticValue: 123,
},
rangeMinimum: {
staticValue: 123,
},
},
},
stringFilterCondition: {
columnName: 'columnName',
comparisonFilterCondition: {
operator: 'operator',
// the properties below are optional
value: {
staticValue: 'staticValue',
},
},
listFilterCondition: {
operator: 'operator',
// the properties below are optional
values: {
staticValues: ['staticValues'],
},
},
},
}],
source: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
},
importTableStep: {
alias: 'alias',
source: {
sourceTableId: 'sourceTableId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
},
joinStep: {
alias: 'alias',
leftOperand: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
onClause: 'onClause',
rightOperand: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
type: 'type',
// the properties below are optional
leftOperandProperties: {
outputColumnNameOverrides: [{
outputColumnName: 'outputColumnName',
// the properties below are optional
sourceColumnName: 'sourceColumnName',
}],
},
rightOperandProperties: {
outputColumnNameOverrides: [{
outputColumnName: 'outputColumnName',
// the properties below are optional
sourceColumnName: 'sourceColumnName',
}],
},
},
pivotStep: {
alias: 'alias',
pivotConfiguration: {
pivotedLabels: [{
labelName: 'labelName',
newColumnId: 'newColumnId',
newColumnName: 'newColumnName',
}],
// the properties below are optional
labelColumnName: 'labelColumnName',
},
source: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
valueColumnConfiguration: {
aggregationFunction: {
listAggregation: {
distinct: false,
separator: 'separator',
// the properties below are optional
inputColumnName: 'inputColumnName',
},
percentileAggregation: {
percentileValue: 123,
// the properties below are optional
inputColumnName: 'inputColumnName',
},
simpleAggregation: {
functionType: 'functionType',
// the properties below are optional
inputColumnName: 'inputColumnName',
},
},
},
// the properties below are optional
groupByColumnNames: ['groupByColumnNames'],
},
projectStep: {
alias: 'alias',
projectedColumns: ['projectedColumns'],
source: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
},
renameColumnsStep: {
alias: 'alias',
renameColumnOperations: [{
columnName: 'columnName',
newColumnName: 'newColumnName',
}],
source: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
},
unpivotStep: {
alias: 'alias',
columnsToUnpivot: [{
columnName: 'columnName',
newValue: 'newValue',
}],
source: {
transformOperationId: 'transformOperationId',
// the properties below are optional
columnIdMappings: [{
sourceColumnId: 'sourceColumnId',
targetColumnId: 'targetColumnId',
}],
},
unpivotedLabelColumnId: 'unpivotedLabelColumnId',
unpivotedLabelColumnName: 'unpivotedLabelColumnName',
unpivotedValueColumnId: 'unpivotedValueColumnId',
unpivotedValueColumnName: 'unpivotedValueColumnName',
},
};
Properties
aggregateStepoptionalIResolvable | CfnDataSet.AggregateOperationPropertyaggregate_stepoptionaltyping.Union[IResolvable, AggregateOperationProperty]aggregateStepoptionalIResolvableAggregateStepoptionalIResolvableAggregateStepoptionalinterface{}#A transform step that groups data and applies aggregation functions to calculate summary values.
appendStepoptionalIResolvable | CfnDataSet.AppendOperationPropertyappend_stepoptionaltyping.Union[IResolvable, AppendOperationProperty]appendStepoptionalIResolvableAppendStepoptionalIResolvableAppendStepoptionalinterface{}#A transform step that combines rows from multiple sources by stacking them vertically.
castColumnTypesStepoptionalIResolvable | CfnDataSet.CastColumnTypesOperationPropertycast_column_types_stepoptionaltyping.Union[IResolvable, CastColumnTypesOperationProperty]castColumnTypesStepoptionalIResolvableCastColumnTypesStepoptionalIResolvableCastColumnTypesStepoptionalinterface{}#A transform step that changes the data types of one or more columns.
createColumnsStepoptionalIResolvable | CfnDataSet.CreateColumnsOperationPropertycreate_columns_stepoptionaltyping.Union[IResolvable, CreateColumnsOperationProperty]createColumnsStepoptionalIResolvableCreateColumnsStepoptionalIResolvableCreateColumnsStepoptionalinterface{}#<p>A transform operation that creates calculated columns.
Columns created in one such operation form a lexical closure.</p>
filtersStepoptionalIResolvable | CfnDataSet.FiltersOperationPropertyfilters_stepoptionaltyping.Union[IResolvable, FiltersOperationProperty]filtersStepoptionalIResolvableFiltersStepoptionalIResolvableFiltersStepoptionalinterface{}#A transform step that applies filter conditions.
importTableStepoptionalIResolvable | CfnDataSet.ImportTableOperationPropertyimport_table_stepoptionaltyping.Union[IResolvable, ImportTableOperationProperty]importTableStepoptionalIResolvableImportTableStepoptionalIResolvableImportTableStepoptionalinterface{}#A transform step that brings data from a source table.
joinStepoptionalIResolvable | CfnDataSet.JoinOperationPropertyjoin_stepoptionaltyping.Union[IResolvable, JoinOperationProperty]joinStepoptionalIResolvableJoinStepoptionalIResolvableJoinStepoptionalinterface{}#A transform step that combines data from two sources based on specified join conditions.
pivotStepoptionalIResolvable | CfnDataSet.PivotOperationPropertypivot_stepoptionaltyping.Union[IResolvable, PivotOperationProperty]pivotStepoptionalIResolvablePivotStepoptionalIResolvablePivotStepoptionalinterface{}#A transform step that converts row values into columns to reshape the data structure.
projectStepoptionalIResolvable | CfnDataSet.ProjectOperationPropertyproject_stepoptionaltyping.Union[IResolvable, ProjectOperationProperty]projectStepoptionalIResolvableProjectStepoptionalIResolvableProjectStepoptionalinterface{}#<p>A transform operation that projects columns.
Operations that come after a projection can only refer to projected columns.</p>
renameColumnsStepoptionalIResolvable | CfnDataSet.RenameColumnsOperationPropertyrename_columns_stepoptionaltyping.Union[IResolvable, RenameColumnsOperationProperty]renameColumnsStepoptionalIResolvableRenameColumnsStepoptionalIResolvableRenameColumnsStepoptionalinterface{}#A transform step that changes the names of one or more columns.
unpivotStepoptionalIResolvable | CfnDataSet.UnpivotOperationPropertyunpivot_stepoptionaltyping.Union[IResolvable, UnpivotOperationProperty]unpivotStepoptionalIResolvableUnpivotStepoptionalIResolvableUnpivotStepoptionalinterface{}#A transform step that converts columns into rows to normalize the data structure.