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',
},
};
python
# The code below shows an example of how to instantiate this type.
# The values are placeholders you should change.
from aws_cdk import aws_quicksight as quicksight
transform_step_property = quicksight.CfnDataSet.TransformStepProperty(
aggregate_step=quicksight.CfnDataSet.AggregateOperationProperty(
aggregations=[quicksight.CfnDataSet.AggregationProperty(
aggregation_function=quicksight.CfnDataSet.DataPrepAggregationFunctionProperty(
list_aggregation=quicksight.CfnDataSet.DataPrepListAggregationFunctionProperty(
distinct=False,
separator="separator",
# the properties below are optional
input_column_name="inputColumnName"
),
percentile_aggregation=quicksight.CfnDataSet.DataPrepPercentileAggregationFunctionProperty(
percentile_value=123,
# the properties below are optional
input_column_name="inputColumnName"
),
simple_aggregation=quicksight.CfnDataSet.DataPrepSimpleAggregationFunctionProperty(
function_type="functionType",
# the properties below are optional
input_column_name="inputColumnName"
)
),
new_column_id="newColumnId",
new_column_name="newColumnName"
)],
alias="alias",
source=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
),
# the properties below are optional
group_by_column_names=["groupByColumnNames"]
),
append_step=quicksight.CfnDataSet.AppendOperationProperty(
alias="alias",
appended_columns=[quicksight.CfnDataSet.AppendedColumnProperty(
column_name="columnName",
new_column_id="newColumnId"
)],
# the properties below are optional
first_source=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
),
second_source=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
)
),
cast_column_types_step=quicksight.CfnDataSet.CastColumnTypesOperationProperty(
alias="alias",
cast_column_type_operations=[quicksight.CfnDataSet.CastColumnTypeOperationProperty(
column_name="columnName",
new_column_type="newColumnType",
# the properties below are optional
format="format",
sub_type="subType"
)],
source=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
)
),
create_columns_step=quicksight.CfnDataSet.CreateColumnsOperationProperty(
columns=[quicksight.CfnDataSet.CalculatedColumnProperty(
column_id="columnId",
column_name="columnName",
expression="expression"
)],
# the properties below are optional
alias="alias",
source=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
)
),
filters_step=quicksight.CfnDataSet.FiltersOperationProperty(
alias="alias",
filter_operations=[quicksight.CfnDataSet.FilterOperationProperty(
condition_expression="conditionExpression",
date_filter_condition=quicksight.CfnDataSet.DataSetDateFilterConditionProperty(
column_name="columnName",
comparison_filter_condition=quicksight.CfnDataSet.DataSetDateComparisonFilterConditionProperty(
operator="operator",
# the properties below are optional
value=quicksight.CfnDataSet.DataSetDateFilterValueProperty(
static_value="staticValue"
)
),
range_filter_condition=quicksight.CfnDataSet.DataSetDateRangeFilterConditionProperty(
include_maximum=False,
include_minimum=False,
range_maximum=quicksight.CfnDataSet.DataSetDateFilterValueProperty(
static_value="staticValue"
),
range_minimum=quicksight.CfnDataSet.DataSetDateFilterValueProperty(
static_value="staticValue"
)
)
),
numeric_filter_condition=quicksight.CfnDataSet.DataSetNumericFilterConditionProperty(
column_name="columnName",
comparison_filter_condition=quicksight.CfnDataSet.DataSetNumericComparisonFilterConditionProperty(
operator="operator",
# the properties below are optional
value=quicksight.CfnDataSet.DataSetNumericFilterValueProperty(
static_value=123
)
),
range_filter_condition=quicksight.CfnDataSet.DataSetNumericRangeFilterConditionProperty(
include_maximum=False,
include_minimum=False,
range_maximum=quicksight.CfnDataSet.DataSetNumericFilterValueProperty(
static_value=123
),
range_minimum=quicksight.CfnDataSet.DataSetNumericFilterValueProperty(
static_value=123
)
)
),
string_filter_condition=quicksight.CfnDataSet.DataSetStringFilterConditionProperty(
column_name="columnName",
comparison_filter_condition=quicksight.CfnDataSet.DataSetStringComparisonFilterConditionProperty(
operator="operator",
# the properties below are optional
value=quicksight.CfnDataSet.DataSetStringFilterValueProperty(
static_value="staticValue"
)
),
list_filter_condition=quicksight.CfnDataSet.DataSetStringListFilterConditionProperty(
operator="operator",
# the properties below are optional
values=quicksight.CfnDataSet.DataSetStringListFilterValueProperty(
static_values=["staticValues"]
)
)
)
)],
source=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
)
),
import_table_step=quicksight.CfnDataSet.ImportTableOperationProperty(
alias="alias",
source=quicksight.CfnDataSet.ImportTableOperationSourceProperty(
source_table_id="sourceTableId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
)
),
join_step=quicksight.CfnDataSet.JoinOperationProperty(
alias="alias",
left_operand=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
),
on_clause="onClause",
right_operand=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
),
type="type",
# the properties below are optional
left_operand_properties=quicksight.CfnDataSet.JoinOperandPropertiesProperty(
output_column_name_overrides=[quicksight.CfnDataSet.OutputColumnNameOverrideProperty(
output_column_name="outputColumnName",
# the properties below are optional
source_column_name="sourceColumnName"
)]
),
right_operand_properties=quicksight.CfnDataSet.JoinOperandPropertiesProperty(
output_column_name_overrides=[quicksight.CfnDataSet.OutputColumnNameOverrideProperty(
output_column_name="outputColumnName",
# the properties below are optional
source_column_name="sourceColumnName"
)]
)
),
pivot_step=quicksight.CfnDataSet.PivotOperationProperty(
alias="alias",
pivot_configuration=quicksight.CfnDataSet.PivotConfigurationProperty(
pivoted_labels=[quicksight.CfnDataSet.PivotedLabelProperty(
label_name="labelName",
new_column_id="newColumnId",
new_column_name="newColumnName"
)],
# the properties below are optional
label_column_name="labelColumnName"
),
source=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
),
value_column_configuration=quicksight.CfnDataSet.ValueColumnConfigurationProperty(
aggregation_function=quicksight.CfnDataSet.DataPrepAggregationFunctionProperty(
list_aggregation=quicksight.CfnDataSet.DataPrepListAggregationFunctionProperty(
distinct=False,
separator="separator",
# the properties below are optional
input_column_name="inputColumnName"
),
percentile_aggregation=quicksight.CfnDataSet.DataPrepPercentileAggregationFunctionProperty(
percentile_value=123,
# the properties below are optional
input_column_name="inputColumnName"
),
simple_aggregation=quicksight.CfnDataSet.DataPrepSimpleAggregationFunctionProperty(
function_type="functionType",
# the properties below are optional
input_column_name="inputColumnName"
)
)
),
# the properties below are optional
group_by_column_names=["groupByColumnNames"]
),
project_step=quicksight.CfnDataSet.ProjectOperationProperty(
alias="alias",
projected_columns=["projectedColumns"],
source=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
)
),
rename_columns_step=quicksight.CfnDataSet.RenameColumnsOperationProperty(
alias="alias",
rename_column_operations=[quicksight.CfnDataSet.RenameColumnOperationProperty(
column_name="columnName",
new_column_name="newColumnName"
)],
source=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
)
),
unpivot_step=quicksight.CfnDataSet.UnpivotOperationProperty(
alias="alias",
columns_to_unpivot=[quicksight.CfnDataSet.ColumnToUnpivotProperty(
column_name="columnName",
new_value="newValue"
)],
source=quicksight.CfnDataSet.TransformOperationSourceProperty(
transform_operation_id="transformOperationId",
# the properties below are optional
column_id_mappings=[quicksight.CfnDataSet.DataSetColumnIdMappingProperty(
source_column_id="sourceColumnId",
target_column_id="targetColumnId"
)]
),
unpivoted_label_column_id="unpivotedLabelColumnId",
unpivoted_label_column_name="unpivotedLabelColumnName",
unpivoted_value_column_id="unpivotedValueColumnId",
unpivoted_value_column_name="unpivotedValueColumnName"
)
)
java
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import software.amazon.awscdk.services.quicksight.*;
TransformStepProperty transformStepProperty = TransformStepProperty.builder()
.aggregateStep(AggregateOperationProperty.builder()
.aggregations(List.of(AggregationProperty.builder()
.aggregationFunction(DataPrepAggregationFunctionProperty.builder()
.listAggregation(DataPrepListAggregationFunctionProperty.builder()
.distinct(false)
.separator("separator")
// the properties below are optional
.inputColumnName("inputColumnName")
.build())
.percentileAggregation(DataPrepPercentileAggregationFunctionProperty.builder()
.percentileValue(123)
// the properties below are optional
.inputColumnName("inputColumnName")
.build())
.simpleAggregation(DataPrepSimpleAggregationFunctionProperty.builder()
.functionType("functionType")
// the properties below are optional
.inputColumnName("inputColumnName")
.build())
.build())
.newColumnId("newColumnId")
.newColumnName("newColumnName")
.build()))
.alias("alias")
.source(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
// the properties below are optional
.groupByColumnNames(List.of("groupByColumnNames"))
.build())
.appendStep(AppendOperationProperty.builder()
.alias("alias")
.appendedColumns(List.of(AppendedColumnProperty.builder()
.columnName("columnName")
.newColumnId("newColumnId")
.build()))
// the properties below are optional
.firstSource(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.secondSource(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.build())
.castColumnTypesStep(CastColumnTypesOperationProperty.builder()
.alias("alias")
.castColumnTypeOperations(List.of(CastColumnTypeOperationProperty.builder()
.columnName("columnName")
.newColumnType("newColumnType")
// the properties below are optional
.format("format")
.subType("subType")
.build()))
.source(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.build())
.createColumnsStep(CreateColumnsOperationProperty.builder()
.columns(List.of(CalculatedColumnProperty.builder()
.columnId("columnId")
.columnName("columnName")
.expression("expression")
.build()))
// the properties below are optional
.alias("alias")
.source(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.build())
.filtersStep(FiltersOperationProperty.builder()
.alias("alias")
.filterOperations(List.of(FilterOperationProperty.builder()
.conditionExpression("conditionExpression")
.dateFilterCondition(DataSetDateFilterConditionProperty.builder()
.columnName("columnName")
.comparisonFilterCondition(DataSetDateComparisonFilterConditionProperty.builder()
.operator("operator")
// the properties below are optional
.value(DataSetDateFilterValueProperty.builder()
.staticValue("staticValue")
.build())
.build())
.rangeFilterCondition(DataSetDateRangeFilterConditionProperty.builder()
.includeMaximum(false)
.includeMinimum(false)
.rangeMaximum(DataSetDateFilterValueProperty.builder()
.staticValue("staticValue")
.build())
.rangeMinimum(DataSetDateFilterValueProperty.builder()
.staticValue("staticValue")
.build())
.build())
.build())
.numericFilterCondition(DataSetNumericFilterConditionProperty.builder()
.columnName("columnName")
.comparisonFilterCondition(DataSetNumericComparisonFilterConditionProperty.builder()
.operator("operator")
// the properties below are optional
.value(DataSetNumericFilterValueProperty.builder()
.staticValue(123)
.build())
.build())
.rangeFilterCondition(DataSetNumericRangeFilterConditionProperty.builder()
.includeMaximum(false)
.includeMinimum(false)
.rangeMaximum(DataSetNumericFilterValueProperty.builder()
.staticValue(123)
.build())
.rangeMinimum(DataSetNumericFilterValueProperty.builder()
.staticValue(123)
.build())
.build())
.build())
.stringFilterCondition(DataSetStringFilterConditionProperty.builder()
.columnName("columnName")
.comparisonFilterCondition(DataSetStringComparisonFilterConditionProperty.builder()
.operator("operator")
// the properties below are optional
.value(DataSetStringFilterValueProperty.builder()
.staticValue("staticValue")
.build())
.build())
.listFilterCondition(DataSetStringListFilterConditionProperty.builder()
.operator("operator")
// the properties below are optional
.values(DataSetStringListFilterValueProperty.builder()
.staticValues(List.of("staticValues"))
.build())
.build())
.build())
.build()))
.source(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.build())
.importTableStep(ImportTableOperationProperty.builder()
.alias("alias")
.source(ImportTableOperationSourceProperty.builder()
.sourceTableId("sourceTableId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.build())
.joinStep(JoinOperationProperty.builder()
.alias("alias")
.leftOperand(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.onClause("onClause")
.rightOperand(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.type("type")
// the properties below are optional
.leftOperandProperties(JoinOperandPropertiesProperty.builder()
.outputColumnNameOverrides(List.of(OutputColumnNameOverrideProperty.builder()
.outputColumnName("outputColumnName")
// the properties below are optional
.sourceColumnName("sourceColumnName")
.build()))
.build())
.rightOperandProperties(JoinOperandPropertiesProperty.builder()
.outputColumnNameOverrides(List.of(OutputColumnNameOverrideProperty.builder()
.outputColumnName("outputColumnName")
// the properties below are optional
.sourceColumnName("sourceColumnName")
.build()))
.build())
.build())
.pivotStep(PivotOperationProperty.builder()
.alias("alias")
.pivotConfiguration(PivotConfigurationProperty.builder()
.pivotedLabels(List.of(PivotedLabelProperty.builder()
.labelName("labelName")
.newColumnId("newColumnId")
.newColumnName("newColumnName")
.build()))
// the properties below are optional
.labelColumnName("labelColumnName")
.build())
.source(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.valueColumnConfiguration(ValueColumnConfigurationProperty.builder()
.aggregationFunction(DataPrepAggregationFunctionProperty.builder()
.listAggregation(DataPrepListAggregationFunctionProperty.builder()
.distinct(false)
.separator("separator")
// the properties below are optional
.inputColumnName("inputColumnName")
.build())
.percentileAggregation(DataPrepPercentileAggregationFunctionProperty.builder()
.percentileValue(123)
// the properties below are optional
.inputColumnName("inputColumnName")
.build())
.simpleAggregation(DataPrepSimpleAggregationFunctionProperty.builder()
.functionType("functionType")
// the properties below are optional
.inputColumnName("inputColumnName")
.build())
.build())
.build())
// the properties below are optional
.groupByColumnNames(List.of("groupByColumnNames"))
.build())
.projectStep(ProjectOperationProperty.builder()
.alias("alias")
.projectedColumns(List.of("projectedColumns"))
.source(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.build())
.renameColumnsStep(RenameColumnsOperationProperty.builder()
.alias("alias")
.renameColumnOperations(List.of(RenameColumnOperationProperty.builder()
.columnName("columnName")
.newColumnName("newColumnName")
.build()))
.source(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.build())
.unpivotStep(UnpivotOperationProperty.builder()
.alias("alias")
.columnsToUnpivot(List.of(ColumnToUnpivotProperty.builder()
.columnName("columnName")
.newValue("newValue")
.build()))
.source(TransformOperationSourceProperty.builder()
.transformOperationId("transformOperationId")
// the properties below are optional
.columnIdMappings(List.of(DataSetColumnIdMappingProperty.builder()
.sourceColumnId("sourceColumnId")
.targetColumnId("targetColumnId")
.build()))
.build())
.unpivotedLabelColumnId("unpivotedLabelColumnId")
.unpivotedLabelColumnName("unpivotedLabelColumnName")
.unpivotedValueColumnId("unpivotedValueColumnId")
.unpivotedValueColumnName("unpivotedValueColumnName")
.build())
.build();
csharp
// Install: dotnet add package Amazon.CDK.Lib
// 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 transformStepProperty = new TransformStepProperty {
AggregateStep = new AggregateOperationProperty {
Aggregations = new [] { new AggregationProperty {
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"
}
},
NewColumnId = "newColumnId",
NewColumnName = "newColumnName"
} },
Alias = "alias",
Source = new TransformOperationSourceProperty {
TransformOperationId = "transformOperationId",
// the properties below are optional
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} }
},
// the properties below are optional
GroupByColumnNames = new [] { "groupByColumnNames" }
},
AppendStep = new AppendOperationProperty {
Alias = "alias",
AppendedColumns = new [] { new AppendedColumnProperty {
ColumnName = "columnName",
NewColumnId = "newColumnId"
} },
// the properties below are optional
FirstSource = new TransformOperationSourceProperty {
TransformOperationId = "transformOperationId",
// the properties below are optional
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} }
},
SecondSource = new TransformOperationSourceProperty {
TransformOperationId = "transformOperationId",
// the properties below are optional
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} }
}
},
CastColumnTypesStep = new CastColumnTypesOperationProperty {
Alias = "alias",
CastColumnTypeOperations = new [] { new CastColumnTypeOperationProperty {
ColumnName = "columnName",
NewColumnType = "newColumnType",
// the properties below are optional
Format = "format",
SubType = "subType"
} },
Source = new TransformOperationSourceProperty {
TransformOperationId = "transformOperationId",
// the properties below are optional
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} }
}
},
CreateColumnsStep = 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"
} }
}
},
FiltersStep = new FiltersOperationProperty {
Alias = "alias",
FilterOperations = new [] { 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" }
}
}
}
} },
Source = new TransformOperationSourceProperty {
TransformOperationId = "transformOperationId",
// the properties below are optional
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} }
}
},
ImportTableStep = new ImportTableOperationProperty {
Alias = "alias",
Source = new ImportTableOperationSourceProperty {
SourceTableId = "sourceTableId",
// the properties below are optional
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} }
}
},
JoinStep = new JoinOperationProperty {
Alias = "alias",
LeftOperand = new TransformOperationSourceProperty {
TransformOperationId = "transformOperationId",
// the properties below are optional
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} }
},
OnClause = "onClause",
RightOperand = new TransformOperationSourceProperty {
TransformOperationId = "transformOperationId",
// the properties below are optional
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} }
},
Type = "type",
// the properties below are optional
LeftOperandProperties = new JoinOperandPropertiesProperty {
OutputColumnNameOverrides = new [] { new OutputColumnNameOverrideProperty {
OutputColumnName = "outputColumnName",
// the properties below are optional
SourceColumnName = "sourceColumnName"
} }
},
RightOperandProperties = new JoinOperandPropertiesProperty {
OutputColumnNameOverrides = new [] { new OutputColumnNameOverrideProperty {
OutputColumnName = "outputColumnName",
// the properties below are optional
SourceColumnName = "sourceColumnName"
} }
}
},
PivotStep = 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" }
},
ProjectStep = 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"
} }
}
},
RenameColumnsStep = new RenameColumnsOperationProperty {
Alias = "alias",
RenameColumnOperations = new [] { new RenameColumnOperationProperty {
ColumnName = "columnName",
NewColumnName = "newColumnName"
} },
Source = new TransformOperationSourceProperty {
TransformOperationId = "transformOperationId",
// the properties below are optional
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} }
}
},
UnpivotStep = new UnpivotOperationProperty {
Alias = "alias",
ColumnsToUnpivot = new [] { new ColumnToUnpivotProperty {
ColumnName = "columnName",
NewValue = "newValue"
} },
Source = new TransformOperationSourceProperty {
TransformOperationId = "transformOperationId",
// the properties below are optional
ColumnIdMappings = new [] { new DataSetColumnIdMappingProperty {
SourceColumnId = "sourceColumnId",
TargetColumnId = "targetColumnId"
} }
},
UnpivotedLabelColumnId = "unpivotedLabelColumnId",
UnpivotedLabelColumnName = "unpivotedLabelColumnName",
UnpivotedValueColumnId = "unpivotedValueColumnId",
UnpivotedValueColumnName = "unpivotedValueColumnName"
}
};
go
// Install: go get github.com/aws/aws-cdk-go/awscdk/v2
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import "github.com/aws/aws-cdk-go/awscdk"
transformStepProperty := &TransformStepProperty{
AggregateStep: &AggregateOperationProperty{
Aggregations: []interface{}{
&AggregationProperty{
AggregationFunction: &DataPrepAggregationFunctionProperty{
ListAggregation: &DataPrepListAggregationFunctionProperty{
Distinct: jsii.Boolean(false),
Separator: jsii.String("separator"),
// the properties below are optional
InputColumnName: jsii.String("inputColumnName"),
},
PercentileAggregation: &DataPrepPercentileAggregationFunctionProperty{
PercentileValue: jsii.Number(123),
// the properties below are optional
InputColumnName: jsii.String("inputColumnName"),
},
SimpleAggregation: &DataPrepSimpleAggregationFunctionProperty{
FunctionType: jsii.String("functionType"),
// the properties below are optional
InputColumnName: jsii.String("inputColumnName"),
},
},
NewColumnId: jsii.String("newColumnId"),
NewColumnName: jsii.String("newColumnName"),
},
},
Alias: jsii.String("alias"),
Source: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
// the properties below are optional
GroupByColumnNames: []*string{
jsii.String("groupByColumnNames"),
},
},
AppendStep: &AppendOperationProperty{
Alias: jsii.String("alias"),
AppendedColumns: []interface{}{
&AppendedColumnProperty{
ColumnName: jsii.String("columnName"),
NewColumnId: jsii.String("newColumnId"),
},
},
// the properties below are optional
FirstSource: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
SecondSource: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
},
CastColumnTypesStep: &CastColumnTypesOperationProperty{
Alias: jsii.String("alias"),
CastColumnTypeOperations: []interface{}{
&CastColumnTypeOperationProperty{
ColumnName: jsii.String("columnName"),
NewColumnType: jsii.String("newColumnType"),
// the properties below are optional
Format: jsii.String("format"),
SubType: jsii.String("subType"),
},
},
Source: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
},
CreateColumnsStep: &CreateColumnsOperationProperty{
Columns: []interface{}{
&CalculatedColumnProperty{
ColumnId: jsii.String("columnId"),
ColumnName: jsii.String("columnName"),
Expression: jsii.String("expression"),
},
},
// the properties below are optional
Alias: jsii.String("alias"),
Source: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
},
FiltersStep: &FiltersOperationProperty{
Alias: jsii.String("alias"),
FilterOperations: []interface{}{
&FilterOperationProperty{
ConditionExpression: jsii.String("conditionExpression"),
DateFilterCondition: &DataSetDateFilterConditionProperty{
ColumnName: jsii.String("columnName"),
ComparisonFilterCondition: &DataSetDateComparisonFilterConditionProperty{
Operator: jsii.String("operator"),
// the properties below are optional
Value: &DataSetDateFilterValueProperty{
StaticValue: jsii.String("staticValue"),
},
},
RangeFilterCondition: &DataSetDateRangeFilterConditionProperty{
IncludeMaximum: jsii.Boolean(false),
IncludeMinimum: jsii.Boolean(false),
RangeMaximum: &DataSetDateFilterValueProperty{
StaticValue: jsii.String("staticValue"),
},
RangeMinimum: &DataSetDateFilterValueProperty{
StaticValue: jsii.String("staticValue"),
},
},
},
NumericFilterCondition: &DataSetNumericFilterConditionProperty{
ColumnName: jsii.String("columnName"),
ComparisonFilterCondition: &DataSetNumericComparisonFilterConditionProperty{
Operator: jsii.String("operator"),
// the properties below are optional
Value: &DataSetNumericFilterValueProperty{
StaticValue: jsii.Number(123),
},
},
RangeFilterCondition: &DataSetNumericRangeFilterConditionProperty{
IncludeMaximum: jsii.Boolean(false),
IncludeMinimum: jsii.Boolean(false),
RangeMaximum: &DataSetNumericFilterValueProperty{
StaticValue: jsii.Number(123),
},
RangeMinimum: &DataSetNumericFilterValueProperty{
StaticValue: jsii.Number(123),
},
},
},
StringFilterCondition: &DataSetStringFilterConditionProperty{
ColumnName: jsii.String("columnName"),
ComparisonFilterCondition: &DataSetStringComparisonFilterConditionProperty{
Operator: jsii.String("operator"),
// the properties below are optional
Value: &DataSetStringFilterValueProperty{
StaticValue: jsii.String("staticValue"),
},
},
ListFilterCondition: &DataSetStringListFilterConditionProperty{
Operator: jsii.String("operator"),
// the properties below are optional
Values: &DataSetStringListFilterValueProperty{
StaticValues: []*string{
jsii.String("staticValues"),
},
},
},
},
},
},
Source: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
},
ImportTableStep: &ImportTableOperationProperty{
Alias: jsii.String("alias"),
Source: &ImportTableOperationSourceProperty{
SourceTableId: jsii.String("sourceTableId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
},
JoinStep: &JoinOperationProperty{
Alias: jsii.String("alias"),
LeftOperand: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
OnClause: jsii.String("onClause"),
RightOperand: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
Type: jsii.String("type"),
// the properties below are optional
LeftOperandProperties: &JoinOperandPropertiesProperty{
OutputColumnNameOverrides: []interface{}{
&OutputColumnNameOverrideProperty{
OutputColumnName: jsii.String("outputColumnName"),
// the properties below are optional
SourceColumnName: jsii.String("sourceColumnName"),
},
},
},
RightOperandProperties: &JoinOperandPropertiesProperty{
OutputColumnNameOverrides: []interface{}{
&OutputColumnNameOverrideProperty{
OutputColumnName: jsii.String("outputColumnName"),
// the properties below are optional
SourceColumnName: jsii.String("sourceColumnName"),
},
},
},
},
PivotStep: &PivotOperationProperty{
Alias: jsii.String("alias"),
PivotConfiguration: &PivotConfigurationProperty{
PivotedLabels: []interface{}{
&PivotedLabelProperty{
LabelName: jsii.String("labelName"),
NewColumnId: jsii.String("newColumnId"),
NewColumnName: jsii.String("newColumnName"),
},
},
// the properties below are optional
LabelColumnName: jsii.String("labelColumnName"),
},
Source: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
ValueColumnConfiguration: &ValueColumnConfigurationProperty{
AggregationFunction: &DataPrepAggregationFunctionProperty{
ListAggregation: &DataPrepListAggregationFunctionProperty{
Distinct: jsii.Boolean(false),
Separator: jsii.String("separator"),
// the properties below are optional
InputColumnName: jsii.String("inputColumnName"),
},
PercentileAggregation: &DataPrepPercentileAggregationFunctionProperty{
PercentileValue: jsii.Number(123),
// the properties below are optional
InputColumnName: jsii.String("inputColumnName"),
},
SimpleAggregation: &DataPrepSimpleAggregationFunctionProperty{
FunctionType: jsii.String("functionType"),
// the properties below are optional
InputColumnName: jsii.String("inputColumnName"),
},
},
},
// the properties below are optional
GroupByColumnNames: []*string{
jsii.String("groupByColumnNames"),
},
},
ProjectStep: &ProjectOperationProperty{
Alias: jsii.String("alias"),
ProjectedColumns: []*string{
jsii.String("projectedColumns"),
},
Source: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
},
RenameColumnsStep: &RenameColumnsOperationProperty{
Alias: jsii.String("alias"),
RenameColumnOperations: []interface{}{
&RenameColumnOperationProperty{
ColumnName: jsii.String("columnName"),
NewColumnName: jsii.String("newColumnName"),
},
},
Source: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
},
UnpivotStep: &UnpivotOperationProperty{
Alias: jsii.String("alias"),
ColumnsToUnpivot: []interface{}{
&ColumnToUnpivotProperty{
ColumnName: jsii.String("columnName"),
NewValue: jsii.String("newValue"),
},
},
Source: &TransformOperationSourceProperty{
TransformOperationId: jsii.String("transformOperationId"),
// the properties below are optional
ColumnIdMappings: []interface{}{
&DataSetColumnIdMappingProperty{
SourceColumnId: jsii.String("sourceColumnId"),
TargetColumnId: jsii.String("targetColumnId"),
},
},
},
UnpivotedLabelColumnId: jsii.String("unpivotedLabelColumnId"),
UnpivotedLabelColumnName: jsii.String("unpivotedLabelColumnName"),
UnpivotedValueColumnId: jsii.String("unpivotedValueColumnId"),
UnpivotedValueColumnName: jsii.String("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.