# JoinOperationProperty

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

- Source: Generated code
- Type last changed: v2.224.0 · 13 Nov 2025

## 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 joinOperationProperty: quicksight.CfnDataSet.JoinOperationProperty = {
  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',
    }],
  },
};
```

## Properties

- `alias`: string (required) — Alias for this operation.

- `leftOperand`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnDataSet.TransformOperationSourceProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnDataSet.TransformOperationSourceProperty.html) (required) — The left operand for the join operation.

- `leftOperandProperties`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnDataSet.JoinOperandPropertiesProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnDataSet.JoinOperandPropertiesProperty.html) — Properties that control how the left operand's columns are handled in the join result.

- `onClause`: string (required) — The join condition that specifies how to match rows between the left and right operands.

- `rightOperand`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnDataSet.TransformOperationSourceProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnDataSet.TransformOperationSourceProperty.html) (required) — The right operand for the join operation.

- `rightOperandProperties`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnDataSet.JoinOperandPropertiesProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnDataSet.JoinOperandPropertiesProperty.html) — Properties that control how the right operand's columns are handled in the join result.

- `type`: string (required) — The type of join to perform, such as `INNER` , `LEFT` , `RIGHT` , or `OUTER` .
