interface JoinOperationProperty

Language	Type name
.NET	Amazon.CDK.CfnPropertyMixins.AWS.QuickSight.CfnDataSetPropsMixin.JoinOperationProperty
Go	github.com/aws/aws-cdk-go/awscdkcfnpropertymixins/v2/awsquicksight#CfnDataSetPropsMixin_JoinOperationProperty
Java	software.amazon.awscdk.cfnpropertymixins.services.quicksight.CfnDataSetPropsMixin.JoinOperationProperty
Python	aws_cdk.cfn_property_mixins.aws_quicksight.CfnDataSetPropsMixin.JoinOperationProperty
TypeScript	@aws-cdk/cfn-property-mixins » aws_quicksight » CfnDataSetPropsMixin » JoinOperationProperty

A transform operation that combines data from two sources based on specified join conditions.

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

Example

// 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/cfn-property-mixins';
const joinOperationProperty: quicksight.CfnDataSetPropsMixin.JoinOperationProperty = {
  alias: 'alias',
  leftOperand: {
    columnIdMappings: [{
      sourceColumnId: 'sourceColumnId',
      targetColumnId: 'targetColumnId',
    }],
    transformOperationId: 'transformOperationId',
  },
  leftOperandProperties: {
    outputColumnNameOverrides: [{
      outputColumnName: 'outputColumnName',
      sourceColumnName: 'sourceColumnName',
    }],
  },
  onClause: 'onClause',
  rightOperand: {
    columnIdMappings: [{
      sourceColumnId: 'sourceColumnId',
      targetColumnId: 'targetColumnId',
    }],
    transformOperationId: 'transformOperationId',
  },
  rightOperandProperties: {
    outputColumnNameOverrides: [{
      outputColumnName: 'outputColumnName',
      sourceColumnName: 'sourceColumnName',
    }],
  },
  type: 'type',
};

Properties

Name	Type	Description
alias?	string	Alias for this operation.
leftOperand?	IResolvable | TransformOperationSourceProperty	The left operand for the join operation.
leftOperandProperties?	IResolvable | JoinOperandPropertiesProperty	Properties that control how the left operand's columns are handled in the join result.
onClause?	string	The join condition that specifies how to match rows between the left and right operands.
rightOperand?	IResolvable | TransformOperationSourceProperty	The right operand for the join operation.
rightOperandProperties?	IResolvable | JoinOperandPropertiesProperty	Properties that control how the right operand's columns are handled in the join result.
type?	string	The type of join to perform, such as INNER , LEFT , RIGHT , or OUTER .

---

alias?

Type: string (optional)

Alias for this operation.

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

---

leftOperand?

Type: IResolvable | TransformOperationSourceProperty (optional)

The left operand for the join operation.

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-joinoperation.html#cfn-quicksight-dataset-joinoperation-leftoperand

---

leftOperandProperties?

Type: IResolvable | JoinOperandPropertiesProperty (optional)

Properties that control how the left operand's columns are handled in the join result.

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-joinoperation.html#cfn-quicksight-dataset-joinoperation-leftoperandproperties

---

onClause?

Type: string (optional)

The join condition that specifies how to match rows between the left and right operands.

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-joinoperation.html#cfn-quicksight-dataset-joinoperation-onclause

---

rightOperand?

Type: IResolvable | TransformOperationSourceProperty (optional)

The right operand for the join operation.

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-joinoperation.html#cfn-quicksight-dataset-joinoperation-rightoperand

---

rightOperandProperties?

Type: IResolvable | JoinOperandPropertiesProperty (optional)

Properties that control how the right operand's columns are handled in the join result.

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-joinoperation.html#cfn-quicksight-dataset-joinoperation-rightoperandproperties

---

type?

Type: string (optional)

The type of join to perform, such as INNER , LEFT , RIGHT , or OUTER .

See also: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-dataset-joinoperation.html#cfn-quicksight-dataset-joinoperation-type